Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Unanswered: What Should I do with this error

    Event Type: Error
    Event Source: Service Control Manager
    Event Category: None
    Event ID: 7000
    Date: 2004-1-5
    Time: 21:18:24
    User: N/A
    Computer: WIN2K3SRV
    Description:
    The MSSQLSERVER service failed to start due to the following error:
    The service did not start due to a logon failure.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


    Event Type: Error
    Event Source: Service Control Manager
    Event Category: None
    Event ID: 7038
    Date: 2004-1-5
    Time: 21:18:24
    User: N/A
    Computer: WIN2K3SRV
    Description:
    The MSSQLSERVER service was unable to log on as .\Administrator with the currently configured password due to the following error:
    Logon failure: the user has not been granted the requested logon type at this computer.

    To ensure that the service is configured properly, use the Services snap-in in Microsoft Management Console (MMC).

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    =========================================
    that's happened when i set my computer as the domain controller
    and then removed the role as domain controller.
    i found all non-buildin users gone. that's the problem.
    any suggestions without reinstalling sql server 8-)

  2. #2
    Join Date
    Apr 2003
    Location
    SC, USA
    Posts
    51
    I would do pretty much what the error suggests.

    Go to the services applet in the control panel (of the computer management snap-in in MMC) and check the Logon properties of the MSSQLSERVER service. Reenter the password for the account being used (administrator). Make sure that if you are wanting to use a domain admin account (a bad idea) that the domain is also specified in the form DOMAIN\administrator. Click OK. If the account does not already have the 'Log on as a service' right, it will be granted at that time (assuming you are currently logged on as a user with the ability to assign such a right).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •