Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

You are here: Manage Administration Tasks > Configure Service Broker Communications > Configure Service Broker

Configure Service Broker

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

Use Service Broker to configure asynchronous communication between applications on SQL Server instances.

Notes:

Service Broker functionality is available starting with SQL Server 2005 and later.
Service Broker pane is linked to the SQL Server connection that was active by the time you opened Service Broker.

To configure Service Broker for database

Select Tools | Administer | Service Broker.

Note: You can also right-click a database and select Tasks | Service Broker Configuration.

Select a database from the list and click Configure.

The database icon indicates the status of the Service Broker:

= Enabled

= Disabled

Review the following for additional information:

Create new Service Broker	Create a new Service Broker for the current database. All existing conversations are removed and no end window messages are produced.
Receive error messages	Send an error message to all conversations in the database when the database is attached. Use this option to facilitate normal cleanup of conversations.

Configure event notifications. See Set up Event Notifications for more information.

Note: To start communication between SQL Server instances you should configure endpoints or run Transport Security wizard. See Configure Transport Security for more information.