Search code examples
sqlsql-serverservice-broker

Service Broker required port

Does anyone know if there is a port that absolutely has to be open on the SQL server to allow service broker traffic? We were testing what happens when you close off all ports on the SQL server except (1433, 445, 3389) and the query notification still worked. We were under the impression that 4022 has to be open for the service broker to work we a default listening port.

Is there a SQL system view that shows what port the service broker is communicating on?

Is there a command to terminate all active query notifications on a database so the database can be dropped?

Thanks

Solution

  • If your service broker architecture is passing messages between servers (endpoints) then it will need ports other than the normal SQL ones.

    If client code such as query notifications is accessing service broker then it uses SQL statements (with some new syntax) through the standard SQL connection and this part doesn't use any additional ports.