14

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??

1 Answer 1

29

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.

6
  • 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, 2013 at 14:55
  • @user1166999 I updated my answer with a walkthrough. Jan 12, 2013 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, 2013 at 13:08
  • 1
    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. Jan 20, 2013 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, 2013 at 10:57

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .