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
Check out these tips for additional information on the SQL Server 2008 installation
process:
Jeremy Kadlec is a Co-Founder, Editor and Author at MSSQLTips.com with more than 300 contributions. He is also the CTO @ Edgewood Solutions and a six-time SQL Server MVP. Jeremy brings 20+ years of SQL Server DBA and Developer experience to the community after earning a bachelor’s degree from SSU and master’s from UMBC.
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
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
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
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
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
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
"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."
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
Jeremy Kadlec is a Co-Founder, Editor and Author at MSSQLTips.com with more than 300 contributions. He is also the CTO @ Edgewood Solutions and a six-time SQL Server MVP. Jeremy brings 20+ years of SQL Server DBA and Developer experience to the community after earning a bachelor’s degree from SSU and master’s from UMBC.