On SQL Server 2008 R2 disc, I do not see client tools.

Posted on 2014-10-28
Last Modified: 2014-10-28
Please forgive me that I am not a SQL guy, so the questions may be silly.
If my memory serves right, SQL Server 2000 disc contains client tools so that you can do query, etc. from a workstation.
On SQL Server 2008 R2 disc, I do not see the client tools any more. Where should I get them?

Question by:techcity
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
LVL 15

Accepted Solution

Haris Djulic earned 334 total points
ID: 40409176
Here is the link to it, now it is called Microsoft® SQL Server® 2008 Management Studio Express
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 40409196
you click on setup and choose "management tools complete:

Author Comment

ID: 40409310
I also found "Microsoft® SQL Server® 2012 Express" which can be downloaded from the following URL

Is it a good idea to download 2012 instead of 2008? Is it compatible with SQL Server 2008 R2?
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 166 total points
ID: 40409344
the express editions wont show the sql server agent components. other than that, you can connect to SQL 2008 from a 2012 SSRS.
I would still suggest, you click on install and just choose the ssms components
LVL 15

Assisted Solution

by:Haris Djulic
Haris Djulic earned 334 total points
ID: 40409368
Basically, up to you.. 2012 will work with 2008 since the core is almost same (2012 has some improvements) so for you it will be ok...

Author Closing Comment

ID: 40409424
Thank you very much!

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question