Unanswered: SQL Server Error: 10060-login sa-connection drops
We have an issue on our network which drops the connection to SQL2000 and we have to login again using SQL login sa - most of the time it will reconnect immediately or we will get the error msg below.
This is very annoying as some of our software needs to run 24hrs uninterrupted for testing purposes.
I've tried named pipes and that doesn't stop the problem, and I'm using Server Login (SA) authentication model. I've also noticed that some of the Internet access is problematic (i.e. "can't find DSN for Google" type errors, "connection timed out" type errors.
Does anybody know what and/or how to fix this ?
It would be much appreciated !
SQL Server Error: 10060
[Microsoft}[ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
SQL Server Error: 11
[Microsoft}[ODBC SQL Server Driver][DBNETLIB]General Network error.
Check your network documentation.
SQLState:'S1T00' - SQL Server Error : 0
[Microsoft][ODBC SQL Server Driver]Timeout Expired