The session keys for this conversation could not be created or accessed. The database master key is required for this operation. Error

Question

Hi,

I'm getting the following error In sys.transmission_queue in the transmission_status column "The session keys for this conversation could not be created or accessed. The database master key"

I'm using only one Server to Send Messages but I thought you only need the master key if there are two or more Servers used in the Messaging?

Thanks in advance 

Answer 1

Hi ti2,

The master key here is a database level object. For the any database which is involved, you may need to create a database master key which is encrypted by the SQL Server service master key. Alternatively, use the ENCRYPTION = OFF parameter to create an unencrypted dialog. Please pay attention to this similar thread: Database Master Key Error.

For more information: Service Broker Dialog Security.

---

Stephanie Lv

TechNet Community Support