How can we help you today? How can we help you today?

Trusting the server certificate with Windows-Auth On Prem

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?
Chip
0

Comments

2 comments

Sort by
  • chrisqtran
    Hi there,
     
    Can you add ;TrustServerCertificate=true after the connection name as such 
    chrisqtran
    0
  • Chip
    That was exactly what I needed. Thank you @chrisqtran
    Chip
    0

Add comment

Please sign in to leave a comment.