Forum Discussion
encryption support warning message
Anonymous , sql server should be ssl enabled.
refer this for certificate
https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/
Anonymous , sql server should be ssl enabled.
refer this for certificate
https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/
It turns out that, at least in my particular situation, it's more complicated than mere SSL enabling. My SQL Server data source forces encryption. So, it's not true that the connection is unencrypted when I agree to the warning message. It's the same situation as when a web server that uses an SSL certificate with a host name not specified in the certificate. The connection is still encrypted, but it's the user's choice about whether to continue browsing the site.
Because we use CNAMEs, it's just a notification that the connection string name is different than the actual SQL Server name. To resolve, I simply need to include all of the aliases and CNAMEs as subject alternative names in the certificate for the SQL Server SSL configuration.