August 2, 2009 at 4:45 pm
Hi,
Before setting up the service broker objects I have seen in many forums that they create Master key Encryption as below.
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'mypassword'
Can someone tell me what is the use of creating master key encryption.
August 2, 2009 at 7:29 pm
sql server developer (8/2/2009)
Hi,Before setting up the service broker objects I have seen in many forums that they create Master key Encryption as below.
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'mypassword'
Can someone tell me what is the use of creating master key encryption.
Practically speaking, the use is that you can't use Service Broker without it. Really. It's supposed to be optional, but I have never been able to get Service Broker to work for me on any system in any configuration that I tried (even completely local in a single database) without it.
Now in principle I think that it's supposed to provide the underlying encryption protections for all of the other keys in the database. Service Broker is supposed to need this for reliable protection and handshake identification across connections, servers, endpoints etc. Which should mean that you wouldn't need it unless you were doing those things. Nonetheless, I've never found a way to get it to work without it.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 21, 2010 at 4:35 am
RBarryYoung
hi, i want to know that if i am using that broker service then should i need to use master key encryption,
because yesterday in our production server i found that all things are working fine but suddenly message not getting queued and when i look into transmission_queue then it's shows me message as below
"The broker is disabled in the sender's database."
can you please let me know in which situation this can happen
Raj Acharya
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply