November 12, 2009 at 8:36 am
I have a SQL 2000 express DB that hit the 2 gig limit and went in to 'Suspect'
because we need to give it more room, I thought I would just upgrade the box to SQL2005 standard...but when I run the setup of 05 it says:
Name: Microsoft SQL Server Desktop Engine (WhatsUp)
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
It says I'm blocked..because the DB is suspect I was hoping to just upgrade to 05 and everything would be happy again.
November 12, 2009 at 8:48 am
I have not done an inplace upgrade of the SQL 2000 Express Edition to 2005 Std.
But when looked at MDSN
http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx
It does not show that upgrade path exists, which means you cannot do it.
Have you not thought of Installing the Clean SQL 2005 Standard Edition on the Same box and then migrate?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 12, 2009 at 8:53 am
You will need to detach the databases, script the logins, and install Standard. You can attach the databases (same structure) and run the logins. sp_change_users_login can help you sync things.
November 12, 2009 at 11:23 am
Okay since I can't do an inline upgrade..I copied out the MDF & LDF.
then I uninstalled SQL 2000, rebooted.
when I install SQL 2005 it doesn't install Enterprise manager...when I look at the menu all I see is 'configuration tools'
I've tried several times now..what the..?
November 12, 2009 at 11:47 am
SQL 2005 comes with Management Studio.
Do you see that?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 12, 2009 at 11:58 am
Sorry I meant management studio..
no it doesn't install...that
only configuration manager
November 12, 2009 at 12:13 pm
Do you see the SQL and other services you chose install are available in SQL Configuration Manager?
Do you see Business Intelligence Development Studio (BIDS) or Visual Studio 2005 etc, if not able to see then you must have not chosen to install them.
You can install them separately this time but do not choose the SQL Database Engine Components, just install workstation components and client tools.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 12, 2009 at 12:41 pm
Thanks guys...
I needed to delete everything from the SQL2000 instance...including all directories? odd but it worked...
Thanks again..good karma to you all
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply