Installing SQL Server 2005 after Visual Studio 2008
Recently, I was installing Visual Studio 2008 on a fresh Windows Vista installation with standard options (including SQL Express Edition).
SQL Server 2005 wasn’t installed before but that’s what I did as next. Because I want to administrate my DB’s with the management studio I checked the “client tools” option in the setup.
So after installing everything, the setup shut a message that the client tools couldn’t be installed, because there’s an older version already installed.
Name: Microsoft SQL Server 2005 Tools Express Edition
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.Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
The client tools which were installed by the Visual Studio blocking the setup tool to install the management studio etc. After some research in Google, I found the solution for this problem on the MSDN forums.
You need to start the setup from the command line with the parameter “SKUUPGRADE=1″ to force installing the newer versions of the client tools:
cmd>setup.exe SKUUPGRADE=1
This is didn’t work for me. I found that I had to go the Control Pad>Add Remove Programs and uninstall the Client Tools (only) that came with VS2008. After that I was able to install the SQL2005 mgmt studio and client tools.