“The certificate chain was issued by an authority that is not trusted” when connecting DB in VM Role from Azure website
You likely don’t have a CA signed certificate installed in your SQL VM’s trusted root store. If you have Encrypt=True in the connection string, either set that to off (not recommended), or add the following in the connection string: SQL Server will create a self-signed certificate if you don’t install one for it to use, but it … Read more