Thursday, January 26, 2012

How to install SQL Server Client Tools?

In order to install SQL Server Client Tools or SQL Server Client we need to follow below steps.

Start installation by clicking on ‘Setup.exe’ file as how we do for normal installation and it will open wizard which contains different options like Planning, Installation, Maintenance, Tools and so on.
In that select ‘Installation’ and here it will have several options like New Installation, New SQL Failover instance, Add Node and so on.. Here select ‘New installation or add features to existing installation’ option. Then proceed with clicking OK on ‘Setup Support Rules’ , then select ‘New Installation or add features’ option, then enter product key, then select ‘I accept terms and ….’ Option, ‘Next’ button will take you to feature selection page.

Here while installing only SQL Server Client Tools we need to select only below selected options. There is no need to select any other options.


The options we need to select while installing SQL Client tools are

·         Client Tools Connectivity
·         Client Tools Backwards Compatibility
·         Client Tools SDK
·         Management Tools – Basic
·         Management Tools – Complete
·         SQL Client Connectivity SDK

Then proceed clicking on Next by leaving all default options as it is. While selecting the ‘Service Accounts’ select the one as required or you can select  any one of the NT Authority\SYSTEM or NT Authority\Network Service and once installation is done you can change to whatever account needed. Select ‘Authentication Mode’ also as per your company policy. I prefer Windows Authentication and add any of the account that will have Admin rights by clicking on ‘Add’ button and proceed clicking next options leaving the default values and it will finish the installation.

In short in order to install SQL Client Tools we need to select only the below options:

·         Client Tools Connectivity
·         Client Tools Backwards Compatibility
·         Client Tools SDK
·         Management Tools – Basic
·         Management Tools – Complete
·         SQL Client Connectivity SDK

Thanks

18 comments:

  1. Thank you for your help! Going through now! Merci buckets!!!!!!!

    ReplyDelete
  2. We have a team that creates an SMS package for people who need the client tools. Why would they build this so that a license key is required for simple client tools?

    ReplyDelete
    Replies
    1. You can install just the SQL Server client components on a computer that is running client/server applications that connect directly to an instance of SQL Server.

      Delete
  3. Thank you very much! looking for this but nothing was so clear like this.

    ReplyDelete
  4. Perfect! Couldn't find this anywhere. Thank You.

    ReplyDelete
  5. Thank you so much! Saved so much of my time!

    ReplyDelete
  6. Thankyou so much! Just what I wanted!:)

    ReplyDelete