{"id":26554,"date":"2023-07-05T11:31:07","date_gmt":"2023-07-05T09:31:07","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=26554"},"modified":"2023-08-10T10:48:44","modified_gmt":"2023-08-10T08:48:44","slug":"sql-server-tips-cms-connection-error-2146893019-severity-20","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-cms-connection-error-2146893019-severity-20\/","title":{"rendered":"SQL Server Tips: CMS – Connection Error: -2146893019 Severity: 20"},"content":{"rendered":"\n

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:<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

ERROR Message:<\/p>\n\n\n\n

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)<\/em><\/p>\n\n\n\n

Error Number: -2146893019<\/em><\/p>\n\n\n\n

Severity: 20<\/em><\/p>\n\n\n\n

State: 0<\/em><\/p>\n\n\n\n

If I open a connection with the Object Explorer on the same instance, it\u2019s working fine\u2026<\/p>\n\n\n\n

I go to the connection Properties and see that the option \u201cEncrypt Connection\u201d is checked by default:<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

I uncheck the case and it was good.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

The other solution is to check \u201cTrust server certificate\u201d if you need to keep \u201cEncrypt connection\u201d checked:<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

My advise is to check every time the connection properties when you register a new SQL server in your CMS.<\/p>\n\n\n\n

To finish my article, I would simply say that as usual one should read the documentation and the problem would not be a problem \ud83d\ude09:<\/p>\n\n\n\n