Service Broker error message: Dialog security is unavailable for this conversation because there is

Posted by yanigisawa on Stack Overflow See other posts from Stack Overflow or by yanigisawa
Published on 2010-04-08T12:38:46Z Indexed on 2010/04/08 12:43 UTC
Read the original article Hit count: 223

Filed under:

I am getting this error in my sys.transmission_queue table whenever I attempt to send a SQL Service Broker message between two different SQL Server servers. (i.e. the databases are on two different physical machines)

Dialog security is unavailable for this conversation because there is no security 
certificate bound to the database principal (Id: 5).  
Either create a certificate for the principal, or specify ENCRYPTION = OFF 
when beginning the conversation 

When this error refers to "database principal" what is it referring to? (the "master" database? dbo user?) I've used the CREATE CERTIFICATE command, backed up the certificate and created a same named certificate on the other server with the backup .cer file from the first server, but I keep getting this message.

Any help would be appreciated in getting me pointed in the right direction. I must be missing something obvious.

FYI, in my development environment, both the initiating and target databases were on the same physical server, and same SQL instance, and everything was working fine.

© Stack Overflow or respective owner

Related posts about service-broker