March 30, 2009 at 12:08 pm
I cannot update SQL Server 2000 to SQL Server 2008 due to a "Feature Upgrade Failure"
I ran the Upgrade Advisor, and had no failure for SQL Server. However, I did get a failure for DTS.
As I have not used DTS on SQL 2000, I don't know why I am getting this error.
I am upgrading an Evaluation Copy of SQL Server 2008.
I need to know why I get the failure, and more important, how to get around it so I can complete the upgrade.
Thanks
Joel
March 30, 2009 at 12:54 pm
If you only ran the SQL 2008 Upgrade Advisor, it won't catch everything for an upgrade from 2000. You have to run the SQL 2005 Upgrade Advisor first.
March 30, 2009 at 12:55 pm
According to this Microsoft Page upgrades to the Eval Edition are not supported.
March 30, 2009 at 1:02 pm
I totally spaced on the Eval edition comment. Thank you MrDenny!
March 31, 2009 at 8:25 am
I am not updating an evaluation copy. I am updating a registered copy of SQL Server 2000, using an evaluation copy of SQL Server 2008.
I think this is supported.
Joel
March 31, 2009 at 8:39 am
I should not have to check a 2005 to 2008 upgrade, as I never installed 2005.
When I run the upgrade advisor for 2000 to 2008, it shows me that Meta Data Services are not supported. It also shows that I need 2000 DTS Designer components to edit DTS packages.
However, I don't use Meta Data Services, and I don't use DTS packages. The only database that has any Meta Data Services statements or DTS packages is MSDB, and that was automatically installed with 2000.
The "failed error" points to MSDB. I removed all user tables beginning with RTBL(created by Microsoft as part of the original 2000 install) and any stored procedures relating to these tables.
Inspite of this, I still can't install the upgrade as there is one failed error which prohibits the upgrade.
How do I get around this?
March 31, 2009 at 10:44 am
At 2 separate clients that I have upgraded from 2000 to 2008, I had to run the Ugrade Advisor for 2005 prior to the Upgrade Advisor for 2008 to find all of the issues that needed to be resolved. This is the Microsoft recommended method.
Perhaps you can get away without it, but I did not find a way to do so.
I apologize if this information was not helpful.
March 31, 2009 at 12:01 pm
Did you receive any error that said:
"SQL Server 2000 Meta Data Services packages are not supported"
and
"SQL Server 2000 DTS Designer components are required to edit DTS packages"
I get both. I am not using DTS or Meta Data Services. Both messages direct me to the MSDB database. I don't use this database. It was created as part of the SQL 2000 install.
Will running the 2005 Database Adviser tell me how to get around this error?
March 31, 2009 at 12:17 pm
isaacsonj (3/31/2009)
I am not updating an evaluation copy. I am updating a registered copy of SQL Server 2000, using an evaluation copy of SQL Server 2008.I think this is supported.
Joel
I'll refer you back to the link that I posted above. It clearly shows that upgrading into the Eval Edition is not supported.
These are the only supported upgrade paths from SQL Server 2000 to SQL Server 2008.
SQL Server 2000 MSDE can upgrade to SQL Server 2008 Express
SQL Server 2000 Developer can upgrade to SQL Server 2008 Developer
SQL Server 2000 Standard can upgrade to SQL Server 2008 Standard, or SQL Server 2008 Enterprise
SQL Server 2000 Enterprise can upgrade to SQL Server 2008 Enterprise
March 31, 2009 at 12:19 pm
isaacsonj (3/31/2009)
Did you receive any error that said:"SQL Server 2000 Meta Data Services packages are not supported"
and
"SQL Server 2000 DTS Designer components are required to edit DTS packages"
I get both. I am not using DTS or Meta Data Services. Both messages direct me to the MSDB database. I don't use this database. It was created as part of the SQL 2000 install.
Will running the 2005 Database Adviser tell me how to get around this error?
Do you have any DTS packages or Meta Data Services packages listed in Enterprise Manager? If so they may need to be removed before the upgrade adviser will say that the upgrade is ready to go. If indeed you do not use them, then removing them won't be an issue.
March 31, 2009 at 1:06 pm
It seems you were right in the first place.
I just got off the phone with Microsoft and it turns out I cannot "upgrade" 2000 to 2008 with the evaluation copy. I can install 2008 and then copy over all of the databases I want to test, but I can't upgrade.
And the funny part is that only 1 feature failed the upgrade. This feature has to do with the MSDB database.
Thanks for your help
Joel
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply