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.
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