SQL Server no longer working

Question

My SQL server seems to have stopped running. I was working on a Visual studio program and now I cannot access my database. Also SQL Server management Studio cannot connect to it. What services need to be running. I think first I should check these.

---

Mike Gallinger C.Tech. Cutting Edge Computing Software Developer

Answer 1

Can you check-out SQL server logs

http://msdn.microsoft.com/en-us/library/ms187109.aspx

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 2

Hi: I restarted the service SQL Server Agent and my problem is solved. I am not sure why it stopped but it is back working. My Log says Report Server Windows  Service (MSSQLServer). It shows this 3 times with the date and time. It must have been me entering bad data while I was testing the front end in VS. 

---

Mike Gallinger C.Tech. Cutting Edge Computing Software Developer

Answer 3

Hi: I restarted the service SQL Server Agent and my problem is solved. I am not sure why it stopped but it is back working. My Log says Report Server Windows  Service (MSSQLServer). It shows this 3 times with the date and time. It must have been me entering bad data while I was testing the front end in VS. 

---

Mike Gallinger C.Tech. Cutting Edge Computing Software Developer

Hi Mike !

You can start MS SQL Server service by doing following steps;

Go to Run -> services.msc -> SQL Server (YourInstanceName) -> Start

Note : MS SQL Server stops if someone changes the password of the Account which is being used to start the service. You can check this by right clicking the Service Name -> Properties -> Log On

Please let me know if this doesn’t work for you. Hope I have answered you correctly.

Thanks, Hasham Niaz