The target server cannot establish an encrypted connection to the master server (Error: 22026)
This post describes how to fix the error:
MSX enlist failed for JobServer.
An exception occurred while executing a Transact-SQL statement or batch.
The enlist operation failed (reason: SQLServerAgentError: The target server cannot establish an encrypted connection to the master server) (Microsoft SQL Server, Error: 22026)
Cause
This error can occur if the MsxEncrypyChannelOptions registry subkey is not set correctly on the target server.
Resolution
Go to the registry on the target server and modify the value of the registry subkey.
The possible values are defined here:
For my test environment, I set it to 0, which disables the encryption.
Comments
Post a Comment