SCCM Setup with Multi Instances of SQL using different static port

[Francis Tran]

SCCM SETUP WITH DIFFERENT SQL PORT

SQL SERVER CONFIGURATION MANAGER:

Make sure all TCP Dynamic Ports are blank

For every IP interface change the "TCP Port" field to your chosen static port

For the "IP All" Interface change the value of the "TCP Port" field to your chosen Static Port

 

Restart the SQL Engine :

ON SCCM SETUP (CENTRAL SITE, PRIMARY SITE)

Use comma and port number to specified port besides FQDN

Continue with the setup as usual.

You could do the same when setup WSUS Database, SCCM Primary Site Database, ...

Continue monitoring the status of setup progress by clicking on view log button

Edited March 26, 2020 by Francis Tran
adding setup result graph