2

My target server is not receiving the message and the following error shows in the target servers error logs. Service Broker login attempt failed with error: 'Connection handshake failed. There is no compatible encryption algorithm. State 22.'

I am using service broker transport security - certificate based authentication. My master db keys and certs are set, permissions are granted to broker_endpoint. My user db keys and certs are set, permissions are granted to services.

My Endpoints on each server are configured for certificates, have permission to the master db cert, and all my databases are authenticated by the same user.

I am also receiving an error in Sql Trace, on target server: Certificate Not Found.

The problem here is that the service that it is documenting on the same row, in sql trace, is for a different service broker configured on the source server that I didn't reference in my conversations.

When I view sys.certificates, on both servers, all certs are tied to the proper issuer_name.

Any help is appreciated.

Thank you

1

A service broker instance on another server was causing this error. It didn't have a master certificate on the server with error.

I dropped the service broker instance on the other server and the error went away.

  • Would you consider fleshing out your answer slightly and marking the answer as accepted? This would help the community. Thanks. – John aka hot2use Mar 14 '17 at 14:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.