Trusting the server certificate with Windows-Auth On Prem
![Chip](https://us.v-cdn.net/6029854/uploads/defaultavatar/nZUSABQN8JEE0.jpg)
I'm trying to add a SQL Server instance object to my project. I enter the db server name but the connection fails because the certificate chain is issued by an authority that is not trusted. This is a network db server and we have our own CAs. Is there a way to trust the certificate like we can do in SQL Compare?
Tagged:
Best Answer
-
chrisqtran Posts: 135 Silver 3
Hi there,
Can you add;TrustServerCertificate=true
after the connection name as such
Answers