Upgrade issue to 2005 in SBS

[spiego]

I am testing out the SBS 2003 R2 (premium edition) upgrade from SBS 2003 SP1 (premium edition). The upgrade to R2 went fine; however, when running setup to upgrade from sql 2000 to 2005 a message appears saying that the install was blocked due to an invalid upgrade path. Shouldn't I be able to upgrade?

 

[Catadmin]

What edition of SQL Server 2000? What edition of SQL Server 2005?

There are certain versions of SQL Server 2000 that you need before you can upgrade to certain versions of 2k5.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[spiego]

The version of sql that comes with SBS 2003 sp1 premium edition is sql 2000 standard and the version that comes with sbs 2003 R2 premium is sql 2005 workgroup edition.

 

[Catadmin]

SQL 2005 Workgroup edition is technically a "downgrade" from SQL Server 2000 Standard. You can't upgrade that way. The only things you can upgrade to are SQL Server 2005 Standard or Enterprise.

Sorry, but you're going to have to call Microsoft on this one and ask them what they were thinking of when they sent you that WorkGroup package.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[spiego]

Thanks for your feedback, but here is what I found on the MS FAQ website regarding SBS and sql. It doesn't look as if it's a downgrade.

Q. What is the difference between SQL Server 2005 Workgroup Edition (to be included in SBS 2003 R2 Premium) and SQL Server 2000 Standard Edition (included in SBS 2003 Premium)?
A. SQL Server 2005 Workgroup Edition has many of the key new features of SQL Server 2005, including programmability improvements such as common language runtime (CLR) integration and SQL Service Broker support, Reporting Services, including the new end-user reporting tool, Report Builder, and SQL Server Management Studio, a new management tool for SQL Server 2005. These are all new features that come with SQL Server 2005 and are not available in SQL Server 2000 Standard Edition.

For more information on SQL Server 2005 Workgroup Edition, visit

http://www.microsoft.com/sql/editions/workgroup/default.mspx.

 

[Catadmin]

You're missing the key point of that quote:

These are all new features that come with SQL Server 2005 and are not available in SQL Server 2000 Standard Edition.

The same can be said for any version of SQL Server 2005. I'm fairly certain I'm correct about the Workgroup thing because I'm studying for my upgrade cert right now.

MOF, I just checked it against BOL for SQL Server 2005. Topic "upgrading SQL Server, about upgrading SQL Server". SQL 2000 Standard can only be upgraded to 2k5 Standard, Enterprise or Developer.

Sorry. It is a "downgrade" and will not allow you to upgrade.




Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

For the upgrade feature of SQL 2005 to work you have to be installing from an equal or lower edition of SQL. SQL 2000 Standard to SQL 2005 Standard will work fine. SQL 2000 Enterprise to SQL 2005 Standard will not work (as Standard is lower than Enterprise). SQL 2000 Standard to SQL 2005 Workgroup will not work (as Workgroup is lower than Standard).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[spiego]

I hear what you both are saying, but then why include it SBS Premium? Sounds to like we go the shaft from MS. It's my belief that when upgrading from one premium edition to another that there shouldn't be any issues such as this.

 

[Catadmin]

I completely agree. That's why I advised you to call them. First though, how did you get the Standard edition of 2000? Did it come with the original SBS or did you guys buy it separately?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[spiego]

I have SA and I am first trying their unlimited support via the web. Yes, the Standard version did originally come with SBS.

 

[Catadmin]

Let us know what you get from them. You've got me interested as to what these people could have been thinking.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[spiego]

Will do and I completely agree.

 

[spiego]

Well, according to the tech from MS, it is a major gap on their part. However, the only resolution is to backup the databaes, remove SQLServer 2000 and then install SQLServer 2005 and restore the databases.

Thanks to all who participated in this thread.

 

[Catadmin]

So, MS isn't going to fix it for you by sending you the version you need?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[spiego]

Here is the response from MS:

"Regarding your question, I recommend you backup the databases first and restore them once SQL 2005 is installed. To tell the truth, I am also confused with the misleading "upgrade" scenario that SBS provides. At least, the limitation on SQL upgrade should be listed in the FAQ on the SBS homepage to keep our customer informed. I will help you deliver this feedback to corresponding department.

 

[Catadmin]

I think you need to call them back. Unless I'm mistaken, you're going to lose functionality in your Databases by going from Standard to Workgroup. (Check out the features of each to be sure).

That being said, Microsoft should definitely be getting you a copy of Standard for your upgrade so you don't lose anything.

I take it they emailed you instead of talked to you on the phone?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

As he's upgrading SBS not SQL, he will be limited to what comes with SBS. If SBS comes with Workgroup that's all they are going to provide. If features are missing he'll need to either purchase SQL Standard 2005 or stay with SQL 2000.

The question now begs what's the driving force behind the upgrade from SQL 2000 to SQL 2005?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Denny,

That's a good point. He doesn't actually have to upgrade to SQL Server 2005 to do the SBS upgrade, does he?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[spiego]

What's driving this is the BI functionality such as the reporting services.

 

[mrdenny]

If you can't get the SQL switched out to SQL 2005 then you can download the SQL 2000 Reporting Services.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com