• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

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
                                               
0
jonsuns7
Asked:
jonsuns7
  • 3
1 Solution
 
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
 
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
 
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now