In the Windows File Explorer, right-click SQLServerManager<version>.msc, and then click Pin to Start or Pin to taskbar. Windows 8: To open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager<version>.msc such as SQLServerManager12.msc or SQLServerManager13.msc, and then press Enter.
If hit error message
"Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid namespace [0x8004100e]"
Workaround
To work around this problem, open a command prompt, type the following command, and then press ENTER:
mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"
Note For this command to succeed, the Sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\number\Shared folder.The value of number depends on the version of SQL Server:nnn
Microsoft SQL Server 2012 | 110 |
Microsoft SQL Server 2008 R2 | 100 |
Microsoft SQL Server 2008 | 100 |
Microsoft SQL Server 2005 | 90 |