Provider: named pipeline provider, error: 40-unable to open the connection to SQL Server (Microsoft SQL Server, error: 53 ).

We use SQL Server database 2008. After the database is configured, the database cannot be accessed from another computer. The following message is displayed:

"Cannot connect *.*.*.*.

Network-related or instance-specific errors occur when SQL Server establishes a connection. The server is not found or cannot be accessed. Verify that the Instance name is correct and SQL server is configured to allow remote connection. (Proveder: named pipeline provider, error: 40-unable to open the connection to SQL Server) (Microsoft SQL Server, error: 53 )"

The following describes the database configuration steps.

1. If "hybrid mode (SQL Server Authentication and Windows Authentication) (m)" has been selected during installation, and an account and password have been assigned to the SQL server system administrator.

You do not need to reconfigure it. The configuration method is as follows:

Log on to the database using the Windows authentication method and choose instance-> right-click-> properties-> Security-> select "SQL Server and Windows Authentication Mode"-> OK

Log on to the database using the Windows verification method and choose instance-> right-click-> properties-> Security-> login name-> double-click the user name (generally SA)-> SET Password

 

2. Choose Start> All Programs> Microsoft SQL Server 2008> Configuration tool>

SQL Server Configuration Manager-> network configuration-> mssqlserver2008-> double-click "TCP/IP"-> protocol-> enabled-> select "yes"

SQL Server Configuration Manager-> network configuration-> mssqlserver2008-> double-click "TCP/IP"-> ip address-> ipall-> TCP port-> enter "1433" and click OK

3. Choose Start> All Programs> Microsoft SQL Server 2008> configuration tools> SQL Server Configuration Manager> SQL Server service> SQL Server (mssqlserver2008) -> right-click to restart

4. Enter netstat-an in the command line. If "0.0.0.0: 1433" is found, sqlserver is listening.

5. Choose operating system> Security Center> Windows Firewall> exceptions> Add programs.

C: \ Program Files \ microsoft sqlserver \ 90 \ shared \ sqlbrowser.exe

C: \ Program Files \ microsoft sqlserver \ mssql10.mssqlserver \ MSSQL \ binn \ sqlservr.exe

6. Choose operating system> Security Center> Windows Firewall> exception> Add port 1433.

 

Generally, it should be okay to access it in the LAN.

(I am doing public network access, so I still cannot access it here. I checked the information for a long time, but I still don't have a clue. I finally got instructions from someone else to Solve the Problem ~ )

7. If you access the Internet, there is another important step to do:

Find your local connection in "network connection"-> right-click-> properties-> double-click "Internet Protocol (TCP/IP)"-> advanced

-> Select "TCP/IP filtering"-> click "properties" in the lower right corner-> Add 1433 to "TCP port", and click OK all the way.

8. Restart the server.