SQL Server Express 2005 upgrade to SQL Server Standard 2005 blocked
We installed SQL Express that came with MOSS 2007. We purchased SQL Standard and want to upgrade the Express version to the Standard. The SQL Server 2005 Express Edition is version 9.00.2047.00. The are using the command line to run the setup, i.e. setup.exe SKUUPGRADE=1. The setup gets all the way to the point where the existing components are grayed out and the details button reveals a message to the effect that the upgrade is blocked. Can you advise? Thank you.
Do you have client tools installed, if you do uninstall them and try the upgrade again.
ASKER
I don't think I do - where exactly do you go for that? I just did the default install of MOSS2007 and have whatever came with that.
Look in Add/Remove Programs and see if you see the SQL server client tools installed.
ASKER
I don't think we do. How can you check to see if the client tools are installed?
ASKER
Do mean the Server Native Client running on the server and seen in add/remove programs? do I need to uninstall that?
ASKER
And no, there is nothing with "tools" in it located in the add/remove programs.
It should say some thing like "SQL server Client tools..
I would suggest that you just get rid of the Express edition(uninstall it)
and do a fresh install of sql server 2005 standard edition, rather than running the upgrade.
Is there any specific reason you are doing an upgrade rather than just doing a fresh install.
I would suggest that you just get rid of the Express edition(uninstall it)
and do a fresh install of sql server 2005 standard edition, rather than running the upgrade.
Is there any specific reason you are doing an upgrade rather than just doing a fresh install.
ASKER
No, I don't believer we do have the client tools installed. The only sql entry with "client" in its name in add/remove programs is Native Client. Is that Client tools?
Yes..based on some googling around I found out thats what SQL server express client tools are called.
Uninstall the Native client and then try the upgrade.
Uninstall the Native client and then try the upgrade.
ASKER
I uninstalled. Rebooted. Then ran this command:
setup.exe skuupgrade=1
Everything started but then when it started to configure, everything just disappeared.
Uninstalled the Native Client again, rebooted and tried this command:
start /wait setup.exe instancename=officeserver upgrade=sql_engine skuupgrade=1 /qb
and thad the same lack of success.
suggestions?
setup.exe skuupgrade=1
Everything started but then when it started to configure, everything just disappeared.
Uninstalled the Native Client again, rebooted and tried this command:
start /wait setup.exe instancename=officeserver upgrade=sql_engine skuupgrade=1 /qb
and thad the same lack of success.
suggestions?
Try the things mentioned in this thread:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3606516&SiteID=1
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3606516&SiteID=1
ASKER
I had people in to do the MOSS2007 install because I know nothing about sql - when they did the install, that was when we found out about the 4G limit for Express. If I have to uninstall, then I will have to have them back in at an astronomical cost.
Why can't we get the upgrade to work and then all the configuration that the outside people did will remain in tact?
Why can't we get the upgrade to work and then all the configuration that the outside people did will remain in tact?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
We ended up uninstalling Sharepoint and SQL Express, then installing SQL Standard and reinstalling Sharepoint. This solved the problem, but it was a hassle to restore our saved Sharepoint information.
Thanks for your help.
Thanks for your help.