SQL Server 2008 Client Tools Installation

By: Jeremy Kadlec | Read Comments (7) | Print Jeremy is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com and SQL Server MVP since 2009. Related Tips: 1 | 2 | 3 | 4 | More

Problem
I have seen your recent tips (SQL Server 2008 Installation Process) on SQL Server 2008 installations.  I think these are great for installing an instance of SQL Server.  How do I just install the client tools (SQL Server Management Studio, Business Intelligence Management Studio, etc.) on DBA and Developer workstations?  I have reviewed the options in the SQL Server Installation Center, but I am missing that piece of the puzzle to install the client tools.

Solution
The SQL Server 2008 installation process has changed and Microsoft has provided a number of new options and resources for completing the installation.   These options have simplified a number of installation aspects and probably opened up some new opportunities that the SQL Server community was not aware of previously.  For more information on the general SQL Server installation process check out the following tips:

• SQL Server 2008 Installation Process
• SQL Server 2008 Installation Process - Part 2
• SQL Server 2008 Installation Process - Part 3
• Steps to Install SQL Server 2008 Service Pack 1 (SP1)

With that baseline set of information covered, let's jump into the process for installing the SQL Server 2008 client tools (SQL Server Management Studio, Business Intelligence Management Studio, etc.).  In a nutshell, once you run the setup application on your installation media the SQL Server Installation Center will load.  Then navigate to the installation option then select the option to install a new stand-alone instance.  Once you begin this installation process you can just select the client tools to complete the process.  With that being said, here are the detailed steps:

SQL Server 2008 Client Tools Installation

Run the setup program from the installation media to load the SQL Server Installation Center.

Once the SQL Server Installation Center loads navigate to the 'Installation' option and select the 'New SQL Server stand-alone installation or add features to an existing installation' option.  To me this is the key step in the process, i.e. knowing where to start the installation process for the client tools because it is not 100% intuitive.

Many of the screen shots to complete the process are listed in the SQL Server 2008 Installation Process - Part 2 tip.  For the sake of brevity, once you being the installation process the Feature Selection screen is where you have the option to just install the client tools as shown below.

As you complete the process you will be able to confirm your selections by reviewing the options in the Ready to Install screen as shown below.

In this circumstance, the tools are installed in the C:\Program Files\Microsoft SQL Server\ directory.  The tools can also be accessed by navigating to Start | All Programs | Microsoft SQL Server 2008.

Next Steps

• Check out these tips for additional information on the SQL Server 2008 installation process:
  • SQL Server 2008 Installation Process
  • SQL Server 2008 Installation Process - Part 2
  • SQL Server 2008 Installation Process - Part 3
  • Steps to Install SQL Server 2008 Service Pack 1 (SP1)
• Check out more information about SQL Server Management Studio.
• Check out more information about SQL Server 2008.
• Check out more information about SQL Server Integration Services.

Share:

Share

Tweet

Free SQL Server Learning Introduction to SQL Azure Join Herve Roggero on Wednesday, June 13 @ 3:00 PM EST to learn more.

Comments and Feedback:

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code