How to install SQL Server 2008 R2 Client Tools


If you want to install just SQL Server Management Studio and/or the SQL Shared Features such as Business Intelligence Development Studio, Integration Services etc then you will need to run the setup executable from the original SQL media.

Select ‘New SQL Server stand-alone installation or add features to an existing installation’ and accept the default settings to the next few screens. When you get to the ‘Feature Selection’ options completely deselect the ‘Instance Features’ (Database Engine Services/Analysis Services/Reporting Services) instead ticking the relevant ‘Shared Features’.

Continue with the installation and once complete the tools and shared features should be available in All Programs\MS SQL Server 2008 R2

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s