In this very quick, objective and short post, I'll share a tip to open SQL Server Configuration Manager when you can't find its shortcut at all. From time to time, I will go into some client's environment and when I try to find SQL Server Configuration Manager (that tool for configuring SQL services) and I can't find it in the start menu or search:
If you cannot find SQL Configuration Manager on your server, simply open the Start Menu and type:
- SQLServerManager10.msc (SQL Server 2008)
- SQLServerManager11.msc (SQL Server 2012)
- SQLServerManager12.msc (SQL Server 2014)
- SQLServerManager13.msc (SQL Server 2016)
- SQLServerManager14.msc (SQL Server 2017)
- SQLServerManager15.msc (SQL Server 2019)
Remember that you will only return results if this specific version is installed on your server:
You can also go to Start Menu> Run (Shortcut: WinKey + R) and execute these commands:
When you click the “OK” button on the run screen, SQL Server Configuration Manager will open:
Another easy way to locate this executable is by opening the C: \ Windows \ System32 directory (% SystemRoot% \ System32):
Once you open this directory, you can find which versions of SQL Server Configuration Manager are installed:
Just double click to open the app:
If you want to make future uses easier, you can also create a shortcut to this application on your desktop, taskbar, or wherever you want.
And that's it folks!
I said the post would be fast, small and objective .. lol
I hope you enjoyed this tip which is very useful when you first encounter this situation.
Thanks!! It seems that the post Windows update is missing here.
Show de Bola, this tip helped me a lot… congratulations on the content…
This has happened to me too, and I realized it was after Windows updates. What I did was access the mmc and include access to the Sql Server Configuration Manager, but it is always good to know other ways to solve a problem. Thanks for the info.