Enabling Service Broker : Enable secure communication

enrique_aeo
enrique_aeo used Ask the Experts™
on
Hi experts,
i am reading about
Enabling Service Broker
but i do not understand
CREATE MASTER KEY ENCRYPTION

can you explain me, By that i create a master key??
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Well, I think you're going to use SQL Server Service Broker feature for messaging between databases or SQL Servers. So for secure communication you'll create a encrypted key.

You should define a key(like password)
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'your_password'

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial