Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have a windows server 2012 with SQL Server 2012 BI installed.

I can remote desktop and use the sql management studio in the server. However I would like to install that tool - sql management studio 2012 - in my local machine, but I don't see a need for the sql server.

Can I install the tool only??

share|improve this question
add comment

1 Answer 1

up vote 11 down vote accepted

You can run the installer on your local machine. During the feature selection dialog, select "Management Tools - Basic" or "Management Tools - Complete" based on what you need.

Launch the install from the CD/ISO:

Then go to Installation > New SQL Server stand-alone installation or add features to an existing environment. enter image description here

Proceed with next through the next few boxes, even the Install Setup Files

Once complete you will see the below image, click next to proceed: enter image description here You can then install either basic or complete management tools as shown. Select and click next enter image description here

As you can see it is only installing the Management Tools you selected:

enter image description here

Click install and you're all set.

share|improve this answer
    
Hi, thanks for answering. The first question in the wizard, is: New SQL Server Stand-alone - OR - Upgrade from SQL Server 2005, 2008 etc Before hitting any of these two, I am already believing I will endup with SQL Server installed! –  cusco Jan 12 '13 at 14:55
    
@user1166999 I updated my answer with a walkthrough. –  cole Jan 12 '13 at 18:13
    
Thank you for the images. I am installing SQL Management Studio at the moment. I am still doubtful as a shared feature that could not be ticked out is 'Local DB', but I do need the tool. –  cusco Jan 14 '13 at 13:08
    
The older SQL installers were a lot better in this regard. A screen very early in the installer would ask if you were setting up server, client or both. I think this whole question flows from the poor usability of the recent SQL Server installers. –  samsmith Jan 20 '13 at 17:50
    
Hi, I realised I never did provide feedback after installing. I just went trough the instalation and had no SQL server. So I do thank you :) Shame, a couple of months after I did install visual studio and ended up with SQL Server anyway :/ Ow well... –  cusco Oct 28 '13 at 10:57
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.