I'm trying to do a schema compare in VS 2019 with Active Directory Password Authentication. The account I'm using works in SSMS, but fails in VS with the following error, even when TrustedServerCertificate is True.
The certificate chain was issued by an authority that is not trusted
Here is a screenshot of what I'm entering and one with the TrustedServerCertificate property set to true.
Anyone know what could be the issue? Is there something that needs to be enabled on the server?