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.