Windows – Can MS SQL Management Studio 2012 be installed without installing SQL SERVER

sql serverwindows

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

Best Answer

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.

Related Topic