Forum Discussion

XiaogangZheng's avatar
XiaogangZheng
Copper Contributor
Apr 15, 2024

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

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

 

 

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Apr 16, 2024

     

    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.

Resources