1

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?

Driftpeasant
  • 3,217
  • 2
  • 22
  • 28
Ashian
  • 400
  • 1
  • 7
  • 24

2 Answers2

1

What version and edition of SQL Server are you running?

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

John Sansom
  • 643
  • 3
  • 7
  • 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 09:17
0

websites with this behavior are Dotnetnuke and I find that it's a problem in dotnetnuke and not related to sql server settings: more details : http://www.dnnsoftware.com/wiki/under-construction

Ashian
  • 400
  • 1
  • 7
  • 24