How to fix ODBC test result failed

Question

How to fix ODBC test result failed

SuperCoder 376

When we test our ODBC configuration it fails. This use to work fine, but suddenly it stopped. Here is the error message.

"Microsoft ODBC Driver for SQL Server Version 17.10.0006

Running connectivity tests... Attempting connection [Microsoft][ODBC Driver 17 for SQL Server]Unable to complete login process due to delay in opening server connection TESTS FAILED!"

The ODBC information is correct, but the connection to the SQL Server fails. Any ideas?

Anonymous

2025-11-12T10:28:46.6433333+00:00

Hi @SuperCoder ,

Thank you @Erland Sommarskog , your explanation on possible connectivity, resource, and authentication issues is accurate and helpful for diagnosing the ODBC failure.

For further reference, please review Microsoft’s official guide on troubleshooting SQL Server connectivity issues: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/resolve-connectivity-errors-overview

Thank you.
Anonymous

2025-11-18T02:07:12.5233333+00:00

Hi @SuperCoder ,

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

Thank you.

Answer recommended by moderator

0 additional answers

Your answer

Anonymous

2025-11-12T10:28:46.6433333+00:00

Hi @SuperCoder ,

Thank you @Erland Sommarskog , your explanation on possible connectivity, resource, and authentication issues is accurate and helpful for diagnosing the ODBC failure.

For further reference, please review Microsoft’s official guide on troubleshooting SQL Server connectivity issues: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/resolve-connectivity-errors-overview

Thank you.
Anonymous

2025-11-18T02:07:12.5233333+00:00

Hi @SuperCoder ,

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

Thank you.

Answer 1

I think you first need to investigate how you can get better diagnostics. The delay can be due to many reasons:

The SQL Server instance is not reached at all (not running, firewall blocking etc).
The instance is reached, but login cannot be completed due to insufficient resources, for instance no worker threads available.
The instance is reached login cannot be completed due to external reasons, for instance issues with contacting the AD in case of Windows authentication.

You should also try alternate means of connect from the same machine, for instance with SQLCMD (which also uses ODBC).

Share via

How to fix ODBC test result failed

0 additional answers

Your answer