Can MS SQL Management Studio 2012 be installed without installing SQL SERVER?
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??
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.
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: You can then install either basic or complete management tools as shown. Select and click next
As you can see it is only installing the Management Tools you selected:
Click install and you're all set.