SQL Server Tips: CMS – Connection Error: -2146893019 Severity: 20

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:

ERROR Message:

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

Severity: 20

State: 0

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 😉:

• https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/error-message-when-you-connect
• https://learn.microsoft.com/en-us/sql/connect/odbc/connection-troubleshooting?view=sql-server-ver16

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