Cannot restart SQL Server 2008 R2

Posted on 2011-05-09
Last Modified: 2012-05-11
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:

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
Question by:jonsuns7
    LVL 18

    Expert Comment

    Did you see the Events Log?
    LVL 57

    Expert Comment

    by:Raja Jegan R

    Change the Startup account to LocalSystem to get it work..
    LVL 57

    Accepted Solution

    And make sure that you start SQL Server service once you change the startup account to get it work.

    Author Closing Comment

    Excellent Advice and straight to the point. I was able to restart in less than one minute.

    Thanks Again,
    LVL 57

    Expert Comment

    by:Raja Jegan R
    And glad to help you out.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now