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)

The target server cannot establish an encrypted connection to the master 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.

Registry key MsxEncryptChannelOptions


Comments

Popular posts from this blog

LG TV This app will now restart to free up more memory

LG TV Clear All Browsing History Data

LG TV turn off Quick Start in settings