Davide Mauri Blog

Experiences with SQL Server

Making SQL Server 2005 Service Broker work between remote instances

If you need to setup two instances of Sql Server 2005 (I actually did it with Sql Server 2005 "Full" version and with the Express one) you can use the little sample you can find here:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=12084

be aware, anyway, to read my previous posts so that you can correct encryption errors due to April's CTP and also be aware the to able to make the two instances talk togheter you also need to grant the connect permission to the initiator instance.

Here is the code:

USE master
GRANT CONNECT ON ENDPOINT:your_endpoint_name TO your_user

Legacy Comments


Niels Berglund
2005-05-30
re: Making SQL Server 2005 Service Broker work between remote instances
Cool that you are linking to my scripts. I have changed the code slightly, and I believe the syntax is now correct. The new scripts are at: http://staff.develop.com/nielsb/code/routing-aprilctp.zip.


Rushi Desai
2005-06-17
re: Making SQL Server 2005 Service Broker work between remote instances
Mastered the art of setting up endpoints? Then take the BrokerChallenge:

http://blogs.msdn.com/rushidesai/archive/2005/06/15/429649.aspx

Rushi