SQL Server 2005 Express Edition - Part 31 - Distributed Service Broker Environment - Routing

(Marcin Policht) In the previous installment of our series covering features available in SQL Server 2005 Express Edition, we began an overview of a distributed Service Broker environment, by describing the most essential requirements for its sample implementation. For the sake of simplicity, we decided to exclude (for the time being) more advanced functionality such as encryption or certificate-based authentication, focusing instead on a configuration that relies on Active Directory Kerberos protocol to control access to endpoints. In this article, we will continue our presentation, describing the remaining steps necessary to facilitate communication between services residing on separate computers in the same Windows domain, including assigning permissions to execute Service Broker-specific tasks and defining Adjacent Broker Protocol routes.