Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

SQL Server Configuration Manager from Command Line

12 May,2015 by Tom Collins

Question: How can I start SQL Server Configuration  Manager from Command Line?

Answer: To start SQL Server Configuration Manager from Command line is a slightly different reference for every  SQL Server Version.

You can access information normally obtained therough SQL Server Configuration Manager in alternative ways such as SQL Server – Find SQL Server tcp port with Powershell . But SQL Server Configuration Manager remains my primary method to manager configurations


For 2005 - SQLServerManager.msc

For 2008/R2 - SQLServerManager10.msc

For 2012  - SQLServerManager11.msc

For 2014 - SQLServerManager12.msc

For 2016 - SQLServerManager13.msc

For 2017 - SQLServerManager14.msc



Read more on command line access through SSMS and other SSMS topics

SQL Server - Open SSMS on the Command Line - SQL Server DBA

Clear list of server names on SQL Server Management Studio

SQL Server – Open SSMS without the splash screen graphic - SQL ...

Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on SQL Server Configuration Manager from Command Line | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer