login issue

Question

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)

Server Name: LAPTOP-IBT4E2CE

Error Number: -2146893019

Severity: 20

State: 0

Answer 1

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

Answer 2

1. Go to Options button.
2. Tick mark for “Trust server certificate” than
3. click Connect button.