Forum Discussion

Evans25's avatar
Evans25
Copper Contributor
May 10, 2023

Cannot connect to SQL Server 2022

I am new to SQL and database and trying to learn. I installed SQL Server 2022 and SSMS . Unfortunately I can't proceed because of the information below.


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

------------------------------
BUTTONS:

OK
------------------------------

 

I have tired to resolve this searching through the web but doesn't seem to find a solution. Any step-by-step approach.

2 Replies

Sort By
  • Raksha112's avatar
    Raksha112
    Copper Contributor
    May 11, 2023
    You can follow this error using step by step approach:
    1) To use a valid SSL certificate you need to check SQL server instance. We need to check certificate properties by connect it within SSMS by connecting to instance.
    2) Try checking certificate chain too and verify if its trusted or not. It not need to install root CA certificate on running SSMS. You can check by adding Encrypt=False" in SSMS through string.

Resources