How to create a target database

Copy the following code and paste it into the Query Editor window. Then, run the code to create a Service Broker endpoint for this instance of the Database Engine. The Service Broker endpoint establishes the network address to which Service Broker messages are sent. The endpoint uses the Service Broker default TCP port 4022 to establish the remote instance of the Database Engine that will use a Windows Authentication connection to send messages.

Windows authentication works when both computers are in the same domain or in trusted domains. If the computers are not in trusted domains, use certificate security for the endpoints.

Copy the following code and paste it into the query editor window. Change the password in the CREATE MASTER KEY statement. Then, run the code to create the target database for this tutorial. By default, new databases have the ENABLE_BROKER option set to ON. The code also creates a master key and user to support encryption and remote connections.

Copy the following code and paste it into the Query Editor window. Change the file name specified in the BACKUP CERTIFICATE statement to reference a folder on your system. Then, run the code to create the target certificate used to encrypt messages. The folder you specify should have permissions set to allow access to the folder only to your Windows account and the Windows account used to run the Database Engine instance, but not to any other account. For Lesson 2, you must manually copy the InstTargetCertificate.cer file to a folder accessible from the initiator instance.

Copy the following code and paste it into the query editor window, then run the code to create a message type for the session. The message type name and properties specified here must be the same as the message type name and properties created in the next lesson in InstInitiatorDB .

Copy the following code and paste it into the query editor window. Then, run the code to create a convention for the session. The convention name and properties specified here must be the same as the convention name and properties created in the next lesson in InstInitiatorDB .

Copy the following code and paste it into the query editor window. Then, run the code to create the queue and service to use as the target. The CREATE SERVICE statement associates the service with the InstTargetQueue so that all messages sent to the service are received into the InstTargetQueue . CREATE SERVICE also specifies that only sessions that use the previously created //BothDB/2InstSample/SimpleContract can use the service as a target service.