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
Niall292Asked:
Who is Participating?
 
TempDBAConnect With a Mentor 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.
0
 
veeraConnect With a Mentor Commented:
check whether workstation and server services are running...
0
 
bahigeCommented:
Check your firewall.  It is probably blocking sql traffic.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
please use this article to start troubleshooting.
http://www.experts-exchange.com/A_1881.html
0
 
Niall292Author 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
0
 
Niall292Author Commented:
I am not 100% sure what fixed the problem as I read and checked all 3 experts suggestions
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.