Hi Remus, just a quick question for you and the team. Is the following statement
correct?
In a scenario where the sending and the receiving service reside in the same
database and instance, a database master key is not required if and only
if messages are being sent without encryption, which is not the default.
Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/
Hi Kent,
Dialog with encryption generate a session key that has to be stored securely
in the database. This requires a database master key.
If the dialog does not use encryption (encryption = off and no remote
service binding present), then no session key is generated and therefore no
master key is required.
It doesn't matter whether the dialog endpoints are local (even the same db)
or remote.
So your statement is correct, but it can be generalized to this: 'a database
master key is not required if and only a conversation is without encryption,
which is not the default'. The part about the instance/database does not
make any difference about the database master key requirement.

Signature
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
> Hi Remus, just a quick question for you and the team. Is the following
> statement correct?
[quoted text clipped - 7 lines]
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
Kent Tegels - 04 Aug 2006 08:08 GMT
Hello Remus Rusanu [MSFT],
Yeah, I was reminded about RSB after reading your last blog post :)
Cheers,
Kent
> Hi Kent,
>
[quoted text clipped - 30 lines]
>> Kent Tegels, DevelopMentor
>> http://staff.develop.com/ktegels/
---
Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/