solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips













































   Got a SQL tip?
            We want to know!

SQL Server 2008 Client Tools Installation

MSSQLTips author Jeremy Kadlec By:   |   Read Comments (22)   |   Related Tips: 1 | 2 | 3 | 4 | More > Install and Uninstall

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:

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



Last Update: 8/3/2009


About the author
MSSQLTips author Jeremy Kadlec
Jeremy Kadlec is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com, Baltimore SSUG co-leader and SQL Server MVP since 2009.

View all my tips


print tip Print  
Become a paid author





join MSSQLTips for free SQL Server tips     



Learn more about SQL Server tools
Post a comment or let the author know this tip helped you.

       All comments are reviewed, so stay on subject or we may delete your comment.

*Name   *Email Notify for updates



       Note: your email address is not published. Required fields are marked with an asterisk (*)


Get free SQL tips:

*Enter Code refresh code     



Thursday, January 09, 2014 - 3:56:41 AM - Shabu Read The Tip

Nice article and MS Setup do miss the guide setup installation. This artice really helped me. Thanks Jermey


Monday, March 18, 2013 - 6:26:54 PM - Jeremy Kadlec Read The Tip

Jeff,

In general yes, that should not be a problem.

Thank you,
Jeremy Kadlec
Community Co-Leader


Monday, March 18, 2013 - 11:34:13 AM - Jeff Read The Tip

I am running a server with SQL 2005 installed.  Can i install the Microsoft SQL Server 2008 Management Studio Express on that server and not cause trouble?  The SSMS 2005 Client is installed. 

Just wondering if this can cause any trouble

Jeff


Tuesday, March 12, 2013 - 10:33:41 PM - Omey Samaroo Read The Tip

Perfect, thank you Jeremy. I appreciate your time and guidance. Keep up the great work. I will stop by your forum from time to time to read blogs and learn some more cool things.


Tuesday, March 12, 2013 - 1:02:51 PM - Jeremy Kadlec Read The Tip

Omey,

That should be fine. The file you mentioned is a 32 bit installation for SQL Server Express Edition.

HTH.

Thank you,
Jeremy Kadlec
Community Co-Leader


Tuesday, March 12, 2013 - 11:09:51 AM - Omey Samaroo Read The Tip

Jeremy, thanks for the information. I am really glad I stopped by this forum. On last question as I am unsure which of the files I should start with, perhaps you can suggest the one you think is appropriate. What I need to do is simply to connect from my desktop to the SQL Server and generate a few queries and reports. Will ENU\x86\SQLEXPRADV_x86_ENU.exe do the trick?


Monday, March 11, 2013 - 8:16:13 PM - Jeremy Kadlec Read The Tip

Omey,

No problem.  Have you checked out the SQL Server Express, LocalDB or Developer Editions?  Check out these URLs:

 

Express

http://www.mssqltips.com/sql-server-tip-category/111/express-edition/

http://www.microsoft.com/en-us/download/details.aspx?id=29062

 

LocalDB Edition

http://www.mssqltips.com/sqlservertip/2694/getting-started-with-sql-server-2012-express-localdb/

 

Developer Edition

http://www.microsoftstore.com/store/msstore/en_US/pd/ThemeID.27509700/SQL-Server-2012-Developer-Edition/productID.249344600

 

HTH.

Thank you,
Jeremy Kadlec
Community Co-Leader


Monday, March 11, 2013 - 5:12:08 PM - Omey Samaroo Read The Tip

Thank you for your prompt response Jeremy. I am looking for an inexpensive way to access the data from SQL Server Database. Do I have to purchase Client versions and then install (SSMS, BIDS, SSIS, VS, drivers, etc.)?

My apologies if this seems very basic, but I am new to your forum and have not actually used SQL Server in the past. Alternatively, is it possible to use the client tools you mentioned without installing the client or must the client be installed too. Alternatively can Microsoft Access to connect to the SQL Server (cost is a driver).

 


Monday, March 11, 2013 - 2:52:38 PM - Jeremy Kadlec Read The Tip

Omey,

I would recommend using the client tools (SSMS, BIDS, SSIS, VS, drivers, etc.) that were released with the version of SQL Server you are working with or use newer tools.

Thank you,
Jeremy Kadlec
Community Co-Leader


Monday, March 11, 2013 - 1:57:25 PM - Omey Samaroo Read The Tip

Is it possible to use SQL Client 2005 and connect to SQL Server 2008? If so, what is the trade-off of doing so?


Friday, December 28, 2012 - 4:58:00 PM - manuel Read The Tip

That´s great, Jeremy. I just finished to read the tip and and find it very suitable to my needs.

Thanks.

Manuel


Thursday, December 27, 2012 - 3:16:51 PM - Jeremy Kadlec Read The Tip

Manuel,

Have you checked out this tip?

http://www.mssqltips.com/sqlservertip/2024/introduction-to-sql-server-express-2008-r2/

HTH.

Thank you,
Jeremy Kadlec
Community Co-Leader


Saturday, December 22, 2012 - 1:53:35 PM - manuel Read The Tip

Thank you Jeremy, your post clear me about bids as a client component of ms sql to install. But unfortunatelly bids as feature it´s not available for express editions. This is really a problem for me. ¿Is there any way for create an olap cube on express edition and use mdx querying?

thanks in advance


Friday, June 15, 2012 - 3:02:42 PM - Jeremy Kadlec Read The Tip

Micro,

Did you see this paragraph in the tip:

"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."

Does this make sense?

Thank you,
Jeremy Kadlec


Thursday, June 14, 2012 - 4:41:43 AM - Micro Read The Tip

I have installed SQL server 2008 on my server and setup the Database path, How do i install the client SQL and were do i get it.

Thank You


Friday, April 06, 2012 - 3:07:45 PM - Jerry Read The Tip

Have SQL installed, and the remote, still unable after trying everything to get port 1433 to respond.

When I do a port scan, it still shows closed. Any ideas?


Thursday, February 03, 2011 - 1:50:55 PM - Jeremy Kadlec Read The Tip

hriosm,

That is great to hear.  Let us know if we can help out with anyone SQL Server questions you might have.

Thank you,
Jeremy Kadlec


Wednesday, February 02, 2011 - 5:47:00 PM - hriosm Read The Tip

thank you so much!!! for these screenshots, really helpful to do my installation.

 

Best regards


Wednesday, July 21, 2010 - 9:31:37 AM - admin Read The Tip

Take a look at this KB article:

Cannot install SQL Server Management tool on Windows XP or Windows Vista platform using the SQL 2008 DVD included in SBS 2008 premium edition

http://support.microsoft.com/kb/958978


Wednesday, July 21, 2010 - 8:58:08 AM - phil Read The Tip

EditionRequirementCheck Checks whether the SQL Server edition is supported on this operating system. Failed This SQL Server edition is not supported on this operating system. See SQL Server Books Online for information about supported operating systems for SQL Small Business Server edition.

 
Running windows 2008 small business server premium and this is trying to install client on windows xp service pack 3

Tuesday, July 20, 2010 - 3:39:31 PM - admin Read The Tip

What error messages are you getting?


Tuesday, July 20, 2010 - 3:27:17 PM - phil Read The Tip

I have tried this numerous times and I receive failed status for operating system supported for edition.  Using windows xp service pack 3. Any ideas?




 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.