I have a SQL Server 2005 (9.0.3186) which houses a number of small databases for a bunch of applications and for some reason 2 of these seem to have repeated connection issues. The only thing in common that these 2 have is they both use a system DSN from their application servers to connect to the database. The errors that are returned are something like:
ODBC error: (08s01) - [Microsoft][ODBC SQL Server Driver] Communication link failure.
Is there anything I need to look at on the SQL Server box itself to try and help alleviate this problem ?