Product:
Microsoft SQL server 2022
Issue:
When on the server try to login with a SQL account in SSMS you get a error:
TITLE: Connect to Server
ADDITIONAL INFORMATION:
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, Error: -2146893019)
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver–2146893019-database-engine-error
The certificate chain was issued by an authority that is not trusted
Solution:
Mark Trust Server Certificate and click connect.
More Information:
https://support.hcl-software.com/csm?id=kb_article&sysparm_article=KB0109476
https://www.mssqltips.com/sqlservertip/3299/how-to-configure-ssl-encryption-in-sql-server/
https://help.akana.com/content/current/sp/platform_install/install_db_mssql.htm
How to Use a Query to Check an SSL Certificate in SQL Server