Prerequisite check failed

ige dan 125 Reputation points
2023-11-29T08:42:27.81+00:00

When I build a new SCCM, I get the error during prerequisite check even SQL Server service running account is a domain 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.

How to troubleshoot this error?

Microsoft Security | Intune | Configuration Manager | Deployment
Microsoft Security | Intune | Configuration Manager | Other
0 comments No comments
{count} votes

Accepted answer
  1. AllenLiu-MSFT 49,316 Reputation points Microsoft External Staff
    2023-11-30T02:01:41.2333333+00:00

    Hi, @ige dan

    Thank you for posting in Microsoft Q&A forum.

    The error indicates that the SQL Server service is not running under a valid account. To troubleshoot this error, ensure that the SQL Server service is running under a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM.

    Have we change the Service Startup Account follow this guidance:

    https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/scm-services-change-the-service-startup-account?view=sql-server-ver16#SSMSProcedure

    If the domain account still gets the error, we may try to use the LOCAL SYSTEM.


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.