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 |