Microsoft SQL Server comes with a very powerful configuration manager which can be used to manage the SQL Server services and control network visibility and footprint. Working without the SQL Server Configuration Manager is a nightmare for a DBA.
SQL Server Configuration Manager is not available in Windows 8
Many development environments have SQL Server installed on the developer workstations running a Windows 8 operating system. I have been consulted on a couple of instances where the SQL Server Configuration Manager fails to come up in the “Start” menu application list (even using the Search charm does not yield any results).
The SQL Server Configuration Manager is in reality a Microsoft Management Console (MMC) application. Hence, the workaround is to do the following:
- Launch the Search charm
- Search for the SQL Server Configuration Manager MMC snap-in:
- SQL Server 2012 – search for “SQLServerManager11.msc“
- SQL Server 2008R2 – search for “SQLServerManager10.msc“
- Press “Enter” to launch (or alternatively, right-click on the result to pin to the Start Menu or create a shortcut on the desktop)
Further Reading on the SQL Server Configuration Manager
- SQL Server Configuration Manager – Hide your SQL Server Instance [Link]
- #0151 – SQL Server– Which TCP/IP port is my SQL Server listening on? [Link]
- Changing SQL Server Service Account or Password – Avoid restarting SQL Server [Link]
[EDIT, 09/08/2014, 10:55AM IST]: Rectified a typo for the MSC file name related to Configuration Manager for SQL Server 2008 R2.
Until we meet next time,