Errors/Issues connecting via SQL Server Management Studio (SSMS)
SQL Secure Connection Error #1
“A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.) (.Net SqlClient Data Provider)”
Reason:
This error occurs when the common name on the installed SSL certificate does not match the name used.
Resolve the Issue:
To resolve this issue, use the correct SQL hostname displayed in the MS SQL Manager of the control panel.
Sites > Site Account > MS SQL Manager > Manage
SQL Secure Connection Error #2
“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.) (.Net SqlClient Data Provider)”
Reason:
This error occurs because a self-signed certificate is being used for encrypted connections on our SQL server.
Resolve the Issue:
To resolve this issue, you can choose the 'Trust Server Certificate' option in the connection settings of SSMS.