broker and mirroring

Hi,

I tried to setup a service broker from one database to another that is mirrored. I specified the mirror address in the create route sql. When I tried to failover to the mirror database, the message was never sent to the mirror database. I do not see any error in transmission_status of sys.transmission_queue. I do see the following errors in the sql log

Service Broker login attempt failed with error: 'Connection handshake failed. The certificate used by the peer is invalid due to the following reason: Certificate not found. State 89.'. [CLIENT: 10.76.223.38]

The mirror route is not operational. 'TCP://11.78.223.54:4022' is acting as 'Mirror' []. 'TCP://11.78.223.38:4022' is acting as 'Unknown' [].

what should I be checking here?

thanks

P

Hi P,

Looks like you did set up the endpoint authentication between the sender and the mirror, but you did not set up the endpoint authentication between the sender and the principal. Therefore the sender cannot connect to the principal. Exchange the certificates, create the login, grant CONNECT permission etc.

In order to use the mirrored route, the sender's instance must be able to connect and authenticate with both instances involved in the mirroring session (principal and mirror).

HTH,
~ Remus