Export (0) Print
Expand All
1 out of 3 rated this helpful - Rate this topic

Completing a Conversation Between Instances

New: 15 September 2007

This tutorial is intended for users who are new to Service Broker, but are familiar with database concepts and Transact-SQL statements. It will help new users get started by showing them how to build and run a simple conversation between two databases on separate instances of the Database Engine.

This tutorial builds on the tasks that you learned in Completing a Conversation Between Databases. In this tutorial, you will learn how to configure a conversation so that it runs between two instances of the Database Engine.

The steps that you will follow in this tutorial are the same as those you followed in the Completing a Conversation Between Databases tutorial, with these exceptions:

  • The two databases will be on separate instances of the Database Engine.
  • You will learn how to create Service Broker endpoints and routes to establish network connections between two instances.
  • The previous tutorials did not transmit messages on the network. Therefore, they used Database Engine permissions to help protect against unauthorized access to messages. In Lesson 3, you will learn how to create certificates and remote service bindings to encrypt messages on the network.

In this tutorial, the instance of the Database Engine that contains the initiator database is referred to as the initiator instance. The instance that contains the target database is referred to as the target instance.

This tutorial is divided into six lessons:

Lesson 1: Creating the Target Database

In this lesson, you create the target database and all the objects that do not have dependencies on the initiator database. This includes the endpoint, master key, certificate, users, message types, contract, service, and queue.

Lesson 2: Creating the Initiator Database

In this lesson, you create the initiator database and its endpoint, master key, certificate, users, routes, remote service bindings, message types, contract, service, and queue.

Lesson 3: Completing the Target Conversation Objects

In this lesson, you create the target objects that have dependencies on the initiator database. This includes certificates, users, routes, and remote service bindings.

Lesson 4: Beginning the Conversation

In this lesson, you start the conversation and send a request message from the initiator to the target.

Lesson 5: Receiving a Request and Sending a Reply

In this lesson, you receive the request message at the target service and send a reply message back to the initiator.

Lesson 6: Receiving the Reply and Ending the Conversation

In this lesson, you receive the reply message at the initiator service and end the conversation.

To complete this tutorial, you should be familiar with the Transact-SQL language and how to use the Transact-SQL Query Editor in SQL Server Management Studio.

You must have two instances of the Database Engine installed. If the two instances are on separate computers, always connect to each instance from a copy of Management Studio on the same computer. For example, do not connect to the initiator instance from a copy of Management Studio on the target computer.

You must have a single login authorized in both instances. In both instances, the login must be either a member of the sysadmin fixed server role, or have the following permissions to run this tutorial:

  • ALTER ANY LINKED SERVER.
  • CREATE ENDPOINT.
  • At least one of the CREATE DATABASE, CREATE ANY DATABASE, or ALTER ANY DATABASE permissions.

Both instances of the Database Engine must be running under a Windows account that is a valid login in the other instance.

Both systems must have the following installed:

  • Any edition of SQL Server 2005, but only one of the instances can be SQL Server Express Edition.
  • Either SQL Server Management Studio or Management Studio Express.
  • Internet Explorer 6 or a later version.

The firewalls for both systems must be configured to enable connections to UDP port 1434 and TCP ports 1433 and 4022. Use the Surface Area Configuration tool to ensure that both instances allow remote connections. Use SQL Server Configuration Manager to ensure that the SQL Server Browser service is running on both computers.

Bb839483.note(en-US,SQL.90).gifNote:
When you review the tutorials, we recommend that you add the Next and Previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.