SCCM prerequisites failure

Mike 246 Reputation points
2021-08-12T23:00:27+00:00

I have been reading a lot of this but it seems I have a unique case. I have even change the SCCM port from using 1533 to 1433 and was successful. However this prerequisite still doesn't pass.

![122907-image.png]2

122908-image.png

Also requires me to have this SQL server service running account

122874-image.png

which is already set

122779-image.png

And I'm running a windows 2019 Datacenter. 1 for SCCM 1 for the SQL

122780-image.png

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,318 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. AllenLiu-MSFT 41,376 Reputation points Microsoft Vendor
    2021-08-16T02:54:34.817+00:00

    Hi, @Mike
    Thank you for posting in Microsoft Q&A forum.

    I have even change the SCCM port from using 1533 to 1433 and was successful. However this prerequisite still doesn't pass.

    When configure the TCP/IP Properties, we should set all TCP Dynamic Ports to blank and all TCP ports to 1433, including IP1 to IP4, also IPAll. Then restart all SQL Server services for the SCCM instance.

    For the fail about SQL Server service running account, what account are you using for this service? The logon account for the SQL Server service cannot be a local user account, NT SERVICE\<sql service name> or LOCAL SERVICE. We must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM.
    For the details:
    https://social.technet.microsoft.com/wiki/contents/articles/36617.sccm-2016-troubleshooting-resolve-sql-server-service-account-issue-during-setup.aspx

    For the error Unsupported site server OS version, you may check ConfigMgrPrereq.log for more messages.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Mike 246 Reputation points
    2021-08-19T18:14:19.943+00:00

    I managed to crack my issue. All of this was resolved the moment I added the SCCM computer object in the local administrator of the SQL server.

    Thanks for the time.