Win10 using SQLSERVER2008R2 SQL Server Configuration Manager

Original: Win10 using SQLSERVER2008R2 SQL Server Configuration Manager

Accessing SQL Server Configuration Manager using WINDOWS10

Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a separate program, SQL Server Configuration Manager does not appear as an application when you run Windows 10 .   to open SQL Server Configuration Manager, in the search charm, under Applications, type sqlservermanager11.msc (for SQL Server 2012) or sqlservermanager10.msc (for SQL Server 2008), or type in run, and then press   Enter.

WIN8 win10 Open SQLSERVER2008R2 SQL Server Configuration Manager, run the secondary file directly: "C:\Windows\SysWOW64\SQLServerManager10.msc"

sql Server	c:\windows\syswow64\sqlservermanager13.msc
sql Server	c:\windows\syswow64\sqlservermanager12.msc
sql Server	c:\windows\syswow64\sqlservermanager11.msc
SQL Server 2008	C:\Windows\SysWOW64\SQLServerManager10.msc

In Win10 is installed SQLSERVER2008R2, sometimes after successful installation will find that SQL Server 1433 port access, through the SQL statement to see the port number, found no 1433 port number

-- Query Port number exec 0 1 ' Listening ' At this point, the program can also successfully access the program through the 1434 port number. But sometimes if you want to change the default port number to 1433, you need to use SQL Server Configuration Manager. 

The SQL Server Configuration Manager could not be found by starting the program. And through the Internet search found a friend can directly run "sqlservermanager10.msc", can call up Configuration Manager, but I tried on their own computer, directly run the words will prompt "Windows cannot find Files" Sqlservermanager10.msc "". So I went to find another win7. Sqlsql Server Configuration Manager, right-click property found this point to the "C:\Windows\SysWOW64\SQLServerManager10.msc", so also go to their own computer this directory to find the next, As sure as this file is, run the secondary file to bring up the SQL Server Configuration Manager.

Actually found that the TCP/IP default is actually disabled, open this property found this is the 1433 port number.

Win10 using SQLSERVER2008R2 SQL Server Configuration Manager