Intermittent failed test connections to SQL ODBC
Posted on 2013-10-17
Got a strange problem with an ODBC connection from an app server to a database on a SQL server. The app server is 2003 server. The DB server is 2008R2 with SQL 2008.
When I create the odbc connection and test it, it works the first time, but then the next connection attempts all fail with the error:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Disconnecting from server
A constant ping from the app server shows no dropped packets.
When I try the same odbc from a different app server and the same db server, it connects ok every time.
Any ideas on what might cause this?