Few days ago, I install new instances SQL Server 2022 and the new SSMS by a customer and when I register the instances in the Central Management Servers (CMS), I was surprise by the error coming from the connection test:
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.) (Framework Microsoft SqlClient Data Provider)
Error Number: -2146893019
If I open a connection with the Object Explorer on the same instance, it’s working fine…
I go to the connection Properties and see that the option “Encrypt Connection” is checked by default:
I uncheck the case and it was good.
The other solution is to check “Trust server certificate” if you need to keep “Encrypt connection” checked:
My advise is to check every time the connection properties when you register a new SQL server in your CMS.
To finish my article, I would simply say that as usual one should read the documentation and the problem would not be a problem 😉:
Searching in these good documetations, you can see that it’s linked to the ODBC connection and not to new version of SQL Server.
I hope this little article can help you….