Where Is Sql Configuration Manager in Windows 10?
I Just Have Upgraded to Windows 10. I Can't Find Sql Server Configuration Manager. I Have Mssql 2008 and 2014 Installed but There Is No Configuration Manager...
I just have upgraded to Windows 10. I can't find SQL Server Configuration Manager. I have MSSQL 2008 and 2014 installed but there is no configuration manager in "All Apps".
This is just a picture of how I used to find it in Windows 8.1. In Windows 10 there is SQL Server Management Studio but there is no configuration like there was in Windows 8.1:
In later versions of SQL Server, the configuration manager is implemented as an MMC plugin.
There are two ways of accessing this:
- Navigate to c:\windows\system32 and look for a file with the name SQLServerManagernn.msc, where nn is the version of SQL Server you have installed. For SQLServer 2014, the name is SQLServerManager12.msc. You can double-click on it and you'll see a result. You can also make a shortcut on the desktop if you like.
- A much simpler way is to run the Computer Management applet from Control Panel→Administrative Tools→Computer Management, where you should find the configuration manager installed
check this microsoft doc page for sql server configuration manager.
snippet (May 2021):
SQL Server 2019 C:\Windows\SysWOW64\SQLServerManager15.msc
SQL Server 2017 C:\Windows\SysWOW64\SQLServerManager14.msc
SQL Server 2016 C:\Windows\SysWOW64\SQLServerManager13.msc
SQL Server 2014 C:\Windows\SysWOW64\SQLServerManager12.msc
SQL Server 2012 C:\Windows\SysWOW64\SQLServerManager11.msc
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
