May 26, 2008 at 8:22 am
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 ?
May 30, 2008 at 7:31 pm
Check to see if the Databases have the autoclose option is on.
Select DATABASEPROPERTYEX('model', 'IsAutoClose')
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply