SQL Server Service Broker and Dynamic Ports (SCCM 2012 R2)
I got a mail from a friend of mine that was having some SCCM and SQL difficulties, after a short explanation, I was able to fix it, the problem was the SQL broker service.
The SQL Server Service Broker (SSB) is used to replicate data between database sites. You will need to specify a port that needs to be used by SCCM. So remove the dynamic ports (leave then blank and not at “0”) and specify the port at 1433 (only if its changed).
You can view what port the SSB is using by running the following query on the SCCM SQL server.
SELECT name, protocol_desc, port, state_desc FROM sys.tcp_endpoints WHERE type_desc = ‘SERVICE_BROKER’