SSMS 19.3 connect to SQL Server has different behavior on Registered Servers and Object Explorer

Copper Contributor

Hi,

 

The SSMS (I am currently using 19.3, and other previous versions have the same issue) get error:

 

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server)

 

The problem is: I login directly to the server and execute the SSMS on this server. On Object Explorer, I can connect the database (on the same server) without problem. On Registered Servers panel, I connect to the same server that is on Central Management Servers, it gives me the above error.

 

1.The database server is the same, 

2. The SSMS is the same

 

The only difference is the connection point using different windows on this SSMS. 

 

How to resolve this problem?

 

Thanks

Xiaogang

 

 

1 Reply

 


SSL provider, error: 0 - The certificate chain was issued by an authority that is not trusted.

@XiaogangZheng , you have to turn of connection (SSL) encryption.

Use "Options" => "Additional connection Properties": Encrypt=FALSE.