Search This Blog

Tuesday, April 14, 2015

SCCM - SQL Server service running account error

When installing SCCM 2012 R2 you might see an error like this in the Prerequisite Check.

SQL Server service running account

The logon account for the SQL Server service cannot be a local user account, NT SERVICE\<sql service name> or LOCAL SERVICE.  You must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM.

image

This can easily be changed to a domain service account.

First create the service account in Active Directory, the name the service account according to your standards.

image

Enter a password for the account and select User cannot change password and Password never expires.

image

And then click Finish to create the account.

image

Start SQL Server Configuration Manager on your SQL server.

image

Click SQL Server Services, right-click the name of the SQL Server instance for which you want to change the service startup account, and then click Properties. 

image

Insert account name and password for the service account and click OK.

image

You will se a message asking whether you want to restart the SQL Server service, click Yes.

image

And now SCCM Prerequisite Check does not show the error:

image

3 comments: