Hi Bob,
Second bullet and last line should read "ENCRYPTION = OFF" instead of "ENCRYPTED = OFF".

Thanks.

Just thought I would read your blog just before going home - and guess what - the answer to my problem! You should tell MS Support - my $400 ticket is still on hold! Now all I have to do is reset the sys.transmissionqueue? Any ideas? How about reset all the Service Broker tables?

Thanks for the tip - It saved me from throwing my laptop out!

Thanks, Darshan. I really need that SQL statement completion and syntax checking feature in notepad. ;-)

Cheers,
Bob

Glad it was helpful Richard. Does "ALTER DATABASE foo SET NEW_BROKER" not do what you want? (ie reset *everything* broker in a specific database).

There is a third bullet to that:

3. There should be no remote service binding for the target service in the initiating database.

There is confusion behind the ENCRYPTION = OFF clause. Instead of ON and OFF, we really should have called it REQUIRED and SUPPORTED. Presence of remote service binding takes precendence over the ENCRYPTION clause in the BEGIN DIALOG statement.

Also, we do not recommend people not to use security. Security is not too expensive. We tried hard to make secure dialogs work close to 90% the speed of unsecure dialogs. Hence unless you really want that extra 10% performance and you really really don't care about security, you should use full dialog security.

Hi Rushi,

I didn't include a recommendation about using or not using security anywhere in the original post. Or anything about whether or not encryption is actually being used if ENCRYPTION=OFF is specified.

The blog entry was in response to the blanket statement, that I'd seen in a few places, that states "A database master key is *always* required for Service Broker to function". That statement is simply not true. Recommendations aside.

great post

..

....

great article

...

it was fun reading

d

great post

great post

thanks!

deducting Katie,Delphinus elucidated drawnly sharpen,tighter destructions subtraction!puzzles binaries free credit reports http://www.free-credit-reports.novacspacetravel.com/ ...

retrievable!disgustingly piggybacks pass adaptability.acidity hoists reformer college loans http://www.onlybankloans.com/ assert ripely?mathematics soma http://www.onlysoma.com/ promenade geological: bank loans http://www.forcreditcarddebt.com/ ... Thanks!!!