SCCM – SQL Server service running account error

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

+ posts

Table of Contents

Share this post
Search blog posts
Search
Authors
Modern Workplace consultant and a Microsoft MVP in Enterprise Mobility.

Modern Workplace consultant and a Microsoft MVP in Windows and Devices.

Infrastructure architect with focus on Modern Workplace and Microsoft 365 security.

Cloud & security specialist with focus on Microsoft backend products and cloud technologies.

Cloud & security specialist with focus on Microsoft 365.

Cloud & Security Specialist, with a passion for all things Cybersecurity

Cloud and infrastructure security specialist with background in networking.

Infrastructure architect with focus on design, implementation, migration and consolidation.

Infrastructure consultant with focus on cloud solutions in Office365 and Azure.

Modern workplace and infrastructure architect with a focus on Microsoft 365 and security.

follow us in feedly
Categories

Follow on SoMe