January 4, 2009 at 10:31 am
1) What exactly is Database Master Key?
2) When it should be created?
January 4, 2009 at 12:36 pm
All of the doc says that DB Master Key is optional. However, I have never seen an instance where I could get Service Broker to work without it. So my advice is treat it as though it is required.
What is it?
My understanding is that it's an encryption key that is used to "sign" messages from the database. "Signing" messages is a cryptographically secure way to prove who a message is really from. In routing & message passing it prevents one of the routers from "spoofing" you (spoofing, is hijacking your communications stream and then carrying it on, pretending to be you).
[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]
January 4, 2009 at 1:07 pm
Hi Barry thanks for ur reply. When we are sending message from databaseA to databaseB in a different server do we need to create Master Key in databaseA and use the same Master Key in databaseB? or How do we need to create?
January 4, 2009 at 2:06 pm
No, the Master Key of each database is unique and unrelated to any other database's master key.
[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]
January 4, 2009 at 2:35 pm
You are saying master key is unique to a database. Then how do we use the master key created in databaseA in databaseB of a different instance while setting up the connections?
And one more doubt is it necessary to create routes when sending messages using service broker from databaseA to databaseB in the same instance?
January 4, 2009 at 6:35 pm
You do not use the Database Master Key at all. SQL Server uses it for you. All you have to do is set it up and forget about 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]
January 5, 2009 at 8:15 am
Hi Barry,
Where can we see the created Master Key in Sql server Management Studio?
Or how to know whether the Master Key has been created for an Instance or not?
January 5, 2009 at 8:39 am
use:
select * from sys.symmetric_keys
[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]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply