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 a SQL Server Express 2005 install on a godaddy virtual terminal which currently is only connected to(locally with mgt studio) every few days or so. Every time i try to connect I get a cannot connect to SQL Server error and after a restart it I can connect just fine locally. I was wondering if there is a timeout setting or something that I am missing that I need to change so that if it is not connected to for a while it does not required a restart? any ideas? thanks!

share|improve this question

migrated from stackoverflow.com Mar 7 '10 at 3:47

This question came from our site for professional and enthusiast programmers.

add comment

2 Answers

Sounds like you may have the database AUTO_CLOSE property ON.

See Setting Database Options

share|improve this answer
add comment

As @John Sansom says there is an AUTO_CLOSE option, however from memory (it's an Express feature which I don't use often) I think this only causes a single database to be unloaded from memory. You can tell if the database is being unloaded (and re-loaded on demand) by looking in the Application Event Log.

Since Management Studio by default will try to connect to the master database which isn't unloaded though I don't think this is your problem. Again, I'd suggest looking through the event log to see if there's anything obvious in there? I assume that when you can't connect the MS SQL service is still 'running' ?

share|improve this answer
add comment

Your Answer

 
discard

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