Trusting the server certificate with Windows-Auth On Prem

Chip

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?

chrisqtran

Hi there,
 
Can you add ;TrustServerCertificate=true after the connection name as such 

Chip

That was exactly what I needed. Thank you @chrisqtran