SSB FAQ (1) – Target Queue cannot receive message

SSB FAQ  (1) – Target Queue cannot receive message<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

SSB target queue can not get a message, when the sender sends a message without any error.

Run the following SQL query:

Select * From sys.Transmission_queue

 

SYMPTOM:

Get the following exception info from the Transmission_Status field.

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

 

SOLUTION:

declare @dialog uniqueidentifier

 

BEGIN dialog conversation @dialog

From service Service_OutStock_Sender

To Service 'Service_OutStock_Receiver'

On Contract Contract_OutStock

With Encryption=OFF

….

 

Just include With Encryption=OFF might solve the above issue, because the default value is ON.

 

Another solution is to mark your database as trustworthy:

Alter database db_name set trustworthy on,

and create a master key in both databases:

Create master key encryption by password=’your password’