How to send/recv between services on two instances?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yashgt - 29 May 2008 14:48 GMT

We have 2 databases on 2 different servers. What do I need to do to
set up services that communicate among these 2 DBs through Service
Broker? I could not figure out from Books online. Is there an online
tutorial that explains this?

I believe I would have to create a SB endpoint and both ends. But how
will the Target Service from the initiator side know about the target
endpoint?

Thanks,
Yash

Reply to this Message

Alan Brewer [MSFT] - 29 May 2008 18:28 GMT

There is a tutorial in the current Books Online showing how to configure a
conversation between two instances:

SQL Server 2005: http://msdn.microsoft.com/en-us/library/bb839483.aspx
SQL Server 2008:
http://msdn.microsoft.com/en-us/library/bb839483(SQL.100).aspx

You can download the latest copy of the SQL Server 2005 Books Online by
either running Microsoft Update or using the link in my signature below.

Signature

Alan Brewer [MSFT]
SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message