SQL Service Broker (SCCM 2012 SP1)

Afternoon

Had a nightmare installing SCCM 2012 SP1 on a remote SQL 2012 SP1 instance. The default ports were changed around in SQL

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'

Enjoy.