0

Since three days ago I have problems connecting to SQL Server on a local network using our Access based application which uses linked tables. It happened suddenly and it only happens on my PC which I use for development. All other clients on the network can connect as usually. I tried to create new DSN connections using the following drivers: "SQL Server", "SQL Server Native Client 11.0", "ODBC Driver 11 for SQL Server". None of these can establish successful connection. I searched a lot on the Internet and tried various options, but none worked. I checked and disabled the firewalls on the server and my PC. I can connect to the old SQL Server on the same network on another PC. I tried to create another server instance, but it didn't help. I can connect through SSMS. When I try to create a new DSN connection, the server name is listed in the dropdown box.

Here are some errors that I have faced while trying to establish the connection:

Connection failed:
SQLState: '08001'
SQL Server Error: 0
[Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in opening server connection

Connection failed:
SQLState: 'HYT00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Login timeout expired

Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).

Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

Connection failed:
SQLState: '08001'
SQL Server Error: 10061
[Microsoft][SQL Server Native Client 11.0]TCP Provider: No connection could be made because the target machine actively refused it.

Connection failed:
SQLState: 'HYT00'
SQL Server Error: 0
[Microsoft][SQL Server Native Client 11.0]Login timeout expired

Connection failed:
SQLState: '01000'
SQL Server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).

Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

Thank you in advance.

0

At a quick glance, looks likely to be a delay caused by DNS hostname lookup. I'd try setting the target hostname to its IP address, and retest.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.