Cannot restart SQL Server 2008 R2

I had a problem with SQL Server and was told to reboot the database server. I was surprised to find out that I could stop the database instance but could not restart it.

In Configuration Manager, the process for the SQL Server database instance (MSSQLSERVER) says this under the SQL Server Services
                                                   Log on As:
                                                   NT AUTHORITY\NETWORKSERVICE

                                                  Start Mode says:
                                                   AUTOMATIC

                                                  State:
                                                  STOPPED
                                                 
The database sits on a Virtual Server, we have tried to reboot the virtual server but so far we have had no luck.

Any help is greatly appreciated
                                               
jonsuns7Asked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
And make sure that you start SQL Server service once you change the startup account to get it work.
0
 
dj_alikCommented:
Did you see the Events Log?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> NT AUTHORITY\NETWORKSERVICE

Change the Startup account to LocalSystem to get it work..
0
 
jonsuns7Author Commented:
Excellent Advice and straight to the point. I was able to restart in less than one minute.

Thanks Again,
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Welcome..
And glad to help you out.
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.