up vote 1 down vote favorite
share [g+] share [fb]

I have some websites hosted on IIS7.5 windows 2008 R2 sometimes I am notified that sites report an error on connection to DBs and can't connect to DB while sql server is running. Nothing changed on server. If I restart web site still I get that error message. If I recycle the Application pool, web site can connect to DB again.

I used default setting for Application pool and just change it to work under Network service account. I didn't find any useful information on Windows Log or SQL server logs

How can I find the issue and fix it?

link|improve this question
86% accept rate
Error messages? Stack trace? You're question is too vague to answer in its current form. – Kev Dec 18 '11 at 16:07
the message is same as when DB's User name or password is incorrect. – Ashian Dec 19 '11 at 9:20
feedback

1 Answer

up vote 1 down vote accepted

What version and edition of SQL Server are you running?

Check to make sure that the database property AUTO_CLOSE is set to FALSE.

link|improve this answer
I used SQL server 2008 R2 Express Ed. some db property Auto_Clost was set to true and I fix it – Ashian Dec 19 '11 at 9:17
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.