Shulou(Shulou.com)06/01 Report--

When adding the system DSN SQL Server Native Client 11.0 to the test database, the following error is prompted:

-

Microsoft SQL Server login

-

Connection failed:

SQLState: '08001'

SQL Server error: 2

[Microsoft] [SQL Server Native Client 11.0] named pipe provider: unable to open connection to SQL Server [2].

Connection failed:

SQLState: 'HYT00'

SQL Server error: 0

[Microsoft] [SQL Server Native Client 11.0] login timeout has expired

Connection failed:

SQLState: '08001'

SQL Server error: 2

[Microsoft] [SQL Server Native Client 11.0] A network-related or instance-specific error occurred while establishing a connection with SQL Server. The server cannot be found or cannot be accessed. Check that the instance name is correct and that SQL Server is configured to allow remote connections. For more information, see SQL Server Books online.

Solution: 1. Let the firewall pass through port 1433.

2. In "SQL Server Network configuration"-"MSSQLSERVER Protocol", right-click "Named Pipes" to enable the pipeline protocol.

3. Configure the server address in odbc, select the server computer name and add the instance

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.