How to fix ODBC test result failed
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 56.00000000000001%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SuperCoder
236
Reputation points
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?
SQL Server Database Engine
{count} votes
-
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator2025-08-06T19:59:23.9566667+00:00 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).
Sign in to comment
Sign in to answer