O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

AlwaysOn Availability Group Support

SQL Server 2012 extends its AlwaysOn Availability Group (AAG) support to SSB, enabling remote services to send and receive messages.

To receive remote messages, a service in an availability group must meet the following requirements:

1. Create an Availability Group Listener for each availability group.

2. Configure every SQL Server instance in the AAG with the same SSB endpoint, setting the LISTENER_IP setting to ALL for each, and make sure that each is listening on the same port.

3. Grant the CONNECT permission on each endpoint either to a specific login or to PUBLIC.

4. Ensure that the msdb database (which holds the core SSB structures) contains either a route to your service and SSB instance or a route ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required