\nService Broker security is the subject of confusion even among people who think they know how it works. Some of the confusion occurs because security was tightened up in the last few CTPs.\n<\/p>\n
\nI've read in two different places that Service Broker conversations always need to have a master key in the database(s) where the services run. Not so. You don't need a database master key (and this is in RTM) if:\n<\/p>\n
\n1. Both services (initiator and target) live in the same database
\n2. You begin the conversation using ENCRYPTION = OFF in the BEGIN DIALOG statement\n<\/p>\n
\nENCRYPTED = ON is the default, and you do need a database master key in this case, hence the confusion.<\/p>\n","protected":false},"excerpt":{"rendered":"
Service Broker security is the subject of confusion even among people who think they know how it works. Some of the confusion occurs because security was tightened up in the last few CTPs. I've read in two different places that Service Broker conversations always need to have a master key in the database(s) where the […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,24,28],"tags":[],"class_list":["post-889","post","type-post","status-publish","format-standard","hentry","category-security","category-service-broker","category-sql-server-2005"],"yoast_head":"\n