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.
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.
Enter a password for the account and select User cannot change password and Password never expires.
And then click Finish to create the account.
Start SQL Server Configuration Manager on your SQL server.
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.
Insert account name and password for the service account and click OK.
You will se a message asking whether you want to restart the SQL Server service, click Yes.
And now SCCM Prerequisite Check does not show the error: