login issue

Devendra Kumar Sahu 236 Reputation points
2023-06-02T06:44:27.1966667+00:00

New installation of SQL Server 2022 Enterprise Edition
after installation successful than login it showing error

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)

err

Server Name: LAPTOP-IBT4E2CE

Error Number: -2146893019

Severity: 20

State: 0

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,306 questions
0 comments No comments
{count} votes

Accepted answer
  1. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2023-06-05T01:45:03.0733333+00:00

    Hi @Devendra Kumar Sahu

    This error occurs when attempting to establish an encrypted connection to SQL Server using a non-verifiable certificate.

    You can check out these links:

    https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/error-message-when-you-connect

    https://blog.greglow.com/2020/01/16/sql-sql-server-the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted/.

    Best regards,

    Aniya

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Devendra Kumar Sahu 236 Reputation points
    2023-06-02T07:39:57.1333333+00:00
    1. Go to Options button.
    2. Tick mark for “Trust server certificate” than
    3. click Connect button.

    User's image

    User's image

    0 comments No comments