Tuesday 6 January 2015

Msg 22026, Level 16, State 1, Line 0 The enlist operation failed (reason: SQLServerAgent Error: The target server cannot establish an encrypted connection to the master server 'MSXSERVER\INSTANCE'. Make sure that the MsxEncryptChannelOptions registry subkey is set correctly on the target server.)

you cannot use a certificate for Secure Sockets Layer (SSL) encrypted communications between master servers and some or all of your target servers, but you want to encrypt the channel between them, configure the target server to use the level of security required.
To configure the appropriate level of security required for a specific master server/target server communication channel, set the SQL Server Agent registry subkey\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\dbacentre\SQLServerAgent\MsxEncryptChannelOptions(REG_DWORD) on the target server to one of the following values. 
The value of <dbacentre> is MSSQL.n. For example, MSSQL.1 or MSSQL.3.

If 1 or 2 is specified, you must have SSL enabled on both the master and target servers. If 2 is specified, you must also have a properly signed certificate present on the master server.

Steps , Go to run command ,regedit Enter..


You can find below , MsxEncryptChannelOptions . CLICK on that make 0



Same method you can do it , MSX Server and TSX Servers. Then it will works

No comments:

Post a Comment

Popular Posts