Intended Audience
Users who are trying to connect either SQL Server Management Studio (SSMS) or Power BI to a SQL Server who are receiving an encryption error.
Problem
SQL Databases support encrypted connections. Using encrypted connections are a best practice and are being enabled on some of our databases with more sensitive information. There can be an issue when trying to connect to a SQL Server who requires encrypted connections when the client does not trust the cert used.
In Power BI, you may receive an error that looks like this:
In SSMS, you may receive an error that looks like this:
Solution
This solution should only be used on SQL Servers within our CWF network.
If using Power BI
If using SSMS
- On the Connection Screen, click on Options
- Go to the Connection Properties Tab
- Check both Encrypt connection and Trust server certificate
- Connect to the database
Related articles