Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
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

1 Answer 1

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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