Network-related or instance-specific errors when establishing a connection to SQL Server

After you install SQL Server 2102, run the Management Studio connection database with an error:

A similar error was found on the web. Original link: http://www.jb51.net/article/59352.html

The process is as follows:

1. Open SQL Server Management Configurator

or enter at the command line: sqlservermanager10.msc
2. Click on the MSSQLSERVER protocol and select the TCP/IP protocol on the right page.

3, right click on the TCP/IP protocol, select "Properties", you need to modify the port address of the connection database

4, jump out of the dialog box, there are many TCP/IP ports, find "IP3", change the IP address for their own computer's IP address (or 127.0.0.1) on the TCP port to add 1433, and then select Start

5, "IPALL" all the ports changed to "1433"

6. Restart the service

7, through the above 1-6 steps to set up a good port, reopen SQL Server Management Studio, the server name input: (local) or 127.0.0.1, you can log into the database.

Network-related or instance-specific errors when establishing a connection to SQL Server