❔ MSSQL server is not connecting to server please help me.
TITLE: Connect to Server
------------------------------
Cannot connect to DESKTOP-C2CJAPC.
------------------------------
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
------------------------------
Troubleshoot connectivity issues in SQL Server - SQL Server
Provides an overview of common connectivity issues in SQL Server and describes the tools to troubleshoot the issues.
7 Replies
trustservercertificate=true; add this to your connection string
just a min
where I'm selecting my server name and clicking connect then this error is occuring
oh, o thought u had CLI error, idk whats here
Hwy wait
You were right
Thanks. I check the trust and clicked connect it's done
Thanks a lot
Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.