question

Mike-6205 avatar image
0 Votes"
Mike-6205 asked saldana-msft edited

SCCM prerequisites failure

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


[2]: /answers/storage/attachments/122914-image.png

windows-servermem-cm-general
image.png (3.1 KiB)
image.png (13.3 KiB)
image.png (10.9 KiB)
image.png (18.6 KiB)
image.png (6.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered AllenLiu-MSFT commented

Hi, @Mike-6205
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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

It seems there is no update for a couple of days. May we know the current status of the problem? Is there any other assistance we can provide?

0 Votes 0 ·
Mike-6205 avatar image
0 Votes"
Mike-6205 answered AllenLiu-MSFT commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you very much for the update and we're glad the problem is solved now. Please accept your reply as answer, we believe this will be very beneficial for other community members who have similar questions.

0 Votes 0 ·