14,503 questions
on the connection dialog, click "trust server certificate"
The certificate chain was issued by an authority that is not trusted
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 54%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOA%3C/text%3E%3C/svg%3E)
OHPRS Admin
281
Reputation points
I just upgraded to SQL Server Management Studio 20.2, something I've done many times in the past. This time, when I ran the Studio and attempted to connect, I got the message:
A connection was successfully established with the server, but then an error occured during the login process. (provider: SSL Provider, error: 0 - The certificate chan was issued by an authority that is not trusted.) (MIcrosoft SQL Server.)
I then checked the box "Trust Server Certificate" on the connection dialog and got the message:
A connection was successfully established with the server, but then an error occurred during the login process, (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft AQL Server, Error: 233)
As I said, I've upgraded SQL Server Management Studio frequently as I get notices. This is the first time I've had this happen. Right now, I'm dead in the water with respect to using Management Studio.
How do I fix this?
SQL Server | Other
{count} votes
-
Erland Sommarskog 122.4K Reputation points MVP Volunteer Moderator2025-01-16T22:15:07.73+00:00 Have you check the SQL Server errorlog for message that matches the login failure?
Sign in to comment
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 78,311 Reputation points Volunteer Moderator2025-01-16T18:06:55.18+00:00 -
ZoeHui-MSFT 41,496 Reputation points2025-01-17T02:37:12.2866667+00:00 Hi @OHPRS Admin,
Please check if you have chosen the Trust server certificate.
If you could connect to the server successfully before, try to use SSMS v19 or v18 to see if the issue is related with SSMS20.
Also here is a same thread, you may take a reference to hope it will be helpful.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.