How To JUST install SQL Management Studio 2005 After Installing Visual Studio 2008

From the SQL Server Tools (Disc 2) DVD:

Goto command prompt and execute the following:

\Tools\setup.exe SKUUPGRADE=1

SKUUPGRADE=1 is required as Visual Studio 2008 installs SQL Server Express.  If you don’t include this command line param you may receive the error message:  A component that you have specified in the ADD_LOCAL property is already installed.  To Upgraded the existing component, refer to the template.ini and se the UPGRADE property to the name of the component

This gets around having to install another full SQL Server instance, allowing you to retain the SQL Server Express service that was installed with Visual Studio 2008

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s