SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,947 questions
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(44.800000000000004, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
chrisrdba
431
Reputation points
Hello. I've got an existing server a few years old that we've never had any issues connecting to. However, all of a sudden when trying to create new connections we are getting the message "The certificate chain was issued by an authority that is not trusted.". This is happening in new versions of SSMS, Excel, and SSRS data sources.
I can get around this by adding "TrustServerCertificate=True" to the connection string on the client, but that's not really a long term solution. I did see this link, but again these are solutions for the client. I've already had to have some Excel users implement my workaround and it's not going over very well. It works, but nobody is very happy about it. Is there something I can do on the SQL box itself that will get me around this?
Thanks!
Sign in to answer