SQL Server Service Running Account Failed in SCCM

Introduction

SQL Server Configuration Manager (SSCM) is a tool that is used to manage the SQL Server services and configurations. In SCCM (System Center Configuration Manager), SQL Server is used as a backend database to store the SCCM data. Sometimes, when trying to start the SQL Server service from SSCM, it may fail with an error message "SQL Server Service Running Account Failed". In this article, we will explore the possible reasons for this error and provide solutions to resolve it.

Possible Reasons

There can be several reasons for the "SQL Server Service Running Account Failed" error in SCCM. Some of the common reasons are:

  1. Insufficient privileges: The account used to run the SQL Server service may not have sufficient privileges to start the service.
  2. Incorrect account credentials: The account credentials provided in the SSCM configuration may be incorrect.
  3. Account password expired: If the password for the account used to run the SQL Server service has expired, the service may fail to start.
  4. Account locked: If the account used to run the SQL Server service is locked, the service may fail to start.

Solutions

Let's explore the solutions for each possible reason:

1. Insufficient Privileges

To resolve this issue, follow these steps:

  1. Open the "Services" console by typing "services.msc" in the Run dialog box.
  2. Locate the SQL Server service that is failing to start.
  3. Right-click on the service and select "Properties".
  4. Switch to the "Log On" tab.
  5. Ensure that the account used to run the service has appropriate privileges. If not, click on the "Browse" button and select a different account or modify the privileges for the existing account.

2. Incorrect Account Credentials

To resolve this issue, follow these steps:

  1. Open the "Services" console by typing "services.msc" in the Run dialog box.
  2. Locate the SQL Server service that is failing to start.
  3. Right-click on the service and select "Properties".
  4. Switch to the "Log On" tab.
  5. Update the account credentials with the correct username and password.
  6. Click on the "Apply" button to save the changes.

3. Account Password Expired

To resolve this issue, follow these steps:

  1. Open the "Services" console by typing "services.msc" in the Run dialog box.
  2. Locate the SQL Server service that is failing to start.
  3. Right-click on the service and select "Properties".
  4. Switch to the "Log On" tab.
  5. Click on the "Browse" button and select a different account.
  6. Enter the credentials for the new account and ensure that the password is not expired.
  7. Click on the "Apply" button to save the changes.

4. Account Locked

To resolve this issue, follow these steps:

  1. Open the "Services" console by typing "services.msc" in the Run dialog box.
  2. Locate the SQL Server service that is failing to start.
  3. Right-click on the service and select "Properties".
  4. Switch to the "Log On" tab.
  5. Click on the "Browse" button and select a different account.
  6. Enter the credentials for the new account and ensure that the account is not locked.
  7. Click on the "Apply" button to save the changes.

Conclusion

In this article, we have discussed the possible reasons for the "SQL Server Service Running Account Failed" error in SCCM and provided solutions to resolve it. It is important to ensure that the account used to run the SQL Server service has sufficient privileges, correct credentials, an active password, and is not locked. By following the steps mentioned in this article, you should be able to resolve the error and start the SQL Server service successfully in SCCM.

erDiagram
    ACCOUNT ||--o{ SQL_SERVER_SERVICE : "Runs"
    SQL_SERVER_SERVICE }|--|| SCCM : "Uses"

pie
    title SQL Server Service Running Account Failed in SCCM
    "Insufficient Privileges" : 40
    "Incorrect Account Credentials" : 20
    "Account Password Expired" : 20
    "Account Locked" : 20