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

Error ‘DBNETLIBConnectionOpen (Connect()).SQL Server does not exist or access denied’ with SQL Server 2008

I received this error following a SQL Instance upgrade from MSDE to SQL Server 2008 R2 Express and tried to connect to the SQL Instance remotely via a third party application.

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

Fortunately the solution was simple:

Start the SQL Server Browser service and if required change the Startup Type from Disabled to Automatic

I looked up why the SQL Server Browser service is now disabled by default and the reason is simply that it’s a security best practice to disable the service.