Service broker and database master keys
Posted by: SQL Server 2005 Distilled,
on 21 Nov 2005 |
View original | Bookmarked: 0 time(s)
In my recent presentation to NTSSUG, I mentioned that Service Broker must be enabled and database master key must be created in order for Service Broker communication to work. What I did not mention clearly in my slides was that database master key is NOT required if initiator and target live in the same database and BEGIN DIALOG contains WITH ENCRYPTION = OFF. Thanks Bob for pointing that out.
Summary: If your Service Broker application lives in a single database and you start conversation by specifically...