We help IT Professionals succeed at work.

Cannot connect to SQL Express

I installed SQL express on my PC and also have  VS 2008 so I use SQL express for developing when I reboot my computer everything is great but if I don't use it for a few hours I can't connect to the DB through both VS or SSMS.
I have went and tried to start the SQL Service again but it will not start and I have to reboot my computer again then it works great until the next time I leave it alone for a few hours.

Does anybody have any ideas what causes this.
Thanks in advance
Comment
Watch Question

Commented:
You can check the event viewer to get knowledge of what is happening at that point of time. Apart from that, make the service automatic start so that whenever it is closing you don't have to start it manually.

Also check if there is any rule setup at firewall level.
Apart from that you would also like to enable TCP\IP.
Commented:
check whether workstation and server services are running...

Commented:
Check your firewall.  It is probably blocking sql traffic.
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
please use this article to start troubleshooting.
http://www.experts-exchange.com/A_1881.html
Niall GallagherDeveloper

Author

Commented:
I honestly don't know what has happen, I have check everything you mention except the Firewall and strangely I don't remember changing anything but my development computer has been running now for 4 days without being rebooted and I can still use SQL express.
I'm sure I must of done something in your notes without realising so I can only think of one fair way and that is to split the points
Niall GallagherDeveloper

Author

Commented:
I am not 100% sure what fixed the problem as I read and checked all 3 experts suggestions