How to install SQL Management Studio 2008 R2

SQL Management Studio is the must use tool for SQL database administrators, however every time I’ve needed to install it I’ve been left scratching my head to find the correct download and working out what to select during the installation.

To save others the same frustrations, the direct download links are:

64-bit installation (if you have the 64-bit version of Windows installed) – http://go.microsoft.com/fwlink/?LinkID=228417&clcid=0×409
32-bit installation (if you have the 32-bit version of Windows installed) – http://go.microsoft.com/fwlink/?LinkID=228416&clcid=0×409

Once it is downloaded and ran you will see the following screen

 SQLManagementStudio-Howtoinstall1

Click on ‘New installation or add features to an existing installation.’

 The SQL Server 2008 R2 Setup window will load. When it’s ready, click ‘I accept the licence terms.’ and click ‘Next’

 SQLManagementStudio-Howtoinstall2

Ensure that ‘Management Tools – Basic’ is ticked and then click ‘Next’ (you may untick ‘SQL Client Connectivity SDK)

 SQLManagementStudio-Howtoinstall3

On the Error Reporting page click ‘Next’

SQLManagementStudio-Howtoinstall4

The installation will now begin and will take several minutes to complete.

Once installed you will see the following screen as confirmation. Click ‘Close’ and close the original window.

SQLManagementStudio-Howtoinstall5

 

Tagged in

7 comments on “How to install SQL Management Studio 2008 R2

  1. Thanks ,that was awesome.Anyway, i do have a question on server name.I tried different option s like . and SQLEXPRESS but none of them works.Any help is highly appreciated

    1. Hey Clara – I only ever use the Fully Qualified Domain Name (FQDN) when connecting to the SQL server, for example sqlserver.local If you’re not sure what it is, log into the SQL server (or find someone who is allowed to) Right-click on ‘Computer’ and select ‘Properties’. You’ll find the FQDN under ‘Full computer name’. If you still can’t connect using the FQDN I would suspect there are network, firewall or permission issues. Try pinging the FQDN – does it respond? Can you start a remote desktop session using the FQDN (mstsc -> sqlserver.local).

    2. Hi, I tried all the options but none of them fixed the issue.FQDN is responding when pinging it.I can start remote server using mstsc but once i put “sqlserver.local” i get the following error:

      The remote Desktop can’t connect to the remote computer for one of these reasons:

      1)Remote access to the server is not enabled
      2)The remote computer is turned off
      3)The remote computer is not available on the network

      I tried to turn off firewall but I still face the same issue.

Leave a Comment

Your email address will not be published. Required fields are marked *