Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Windows 8.1, i can't find Configuration manager of SQL Server 2008R2. I have already followed the steps as specified in this question. But Configuration manager is not showing up even after entering 'SQLServerManager10.msc' in Search. Please let me know how to achieve it.

share|improve this question
I always use this press win+F and type configuration manager ,it will be listed in any of the sub lists ,i can't test it since i just uninstalled it due to the lack of the old start button! – Biju jose Mar 21 '14 at 11:25
Do yourself a favour and install something like ClassicShell (alternatives are available) which will give you back proper Win7 type start button functionality. It's gratis and stupid button aside (it can be changed but I think all of them look silly) it does exactly what it says on the tin. Windows 8 is a dogs dinner and totally unsuited to anything but the most casual of users on a desktop. – Steve Pettifer Apr 24 '14 at 7:49

Open run command window using "Windows+R" type mmc.exe after console opened from file menu choose SQLSERVERMANAGER10.

Or you can type "SQLSERVERMANAGER10.msc" in run command window.

share|improve this answer
couldn't find this :/ – mounaim Nov 16 '15 at 12:16

There are multiple methods to open SSCM in Windows 8.1, I actually only have 2012 installed currently after refreshing my laptop but previously had 2008 R2 installed and it worked the same way for me.

Bring up the start menu:

enter image description here

You can also access this by using the search function of the start menu, by just typing Configuration you should get similar results:

enter image description here

share|improve this answer

In Windows 8, SQL Server Configuration Manager shortcut is located in:

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008\Configuration Tools

Please note that ProgramData is a hidden folder. I suggest you create a shortcut on your desktop.

share|improve this answer

Here's where I found it:


NOT pleased with this note: "Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager does not appear as an application in newer versions of Windows." Meaning it's basically undiscoverable by new DBA's. Glad I got in before Windows 8.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.