Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 How to install Microsoft SQL Management Studio?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

27 Posts

Posted - 08/21/2014 :  03:34:53  Show Profile  Reply with Quote
Hi Everyone,

On my works server we have MS SQL Server 2008 R2 installed. However I am successfully using Microsoft SQL Server Management Studio 2012 from my Windows 7 workstation to write queries that access the database. Personally I prefer the 2012 features within Management Studio!

I now want to deploy the Management Studio to a Citrix XenApp Servers. How can I go about installing the Studio alone, without installing the full fledged SQL Server product?

Any suggestions here will be greatly appreciated.

Kind Regards,


Aged Yak Warrior

737 Posts

Posted - 08/21/2014 :  04:41:22  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
1 Insert the SQL Server installation DVD into your computer's drive. The installation wizard automatically starts, and you are presented with an installation splash screen.

2 Click the "Components to Install" link. This link only installs the tools for your SQL Server and not the entire database engine. Check the box labelled "Workstation components, Books Online and development tools" and click "Next."

3 Select "I agree" on the license agreement screen and click "Next." Click "Next" again on the hard drive location screen. The wizard automatically creates the best hard drive location for the Management Studio tools.

4 Click "Next." At the final summary screen, click "Install." The Management Studio software installs on your computer. If you are prompted to reboot the machine, click "Restart" to reboot the computer.

Javeed Ahmed
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000