cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PHorniak Regular Visitor
Regular Visitor

Configure Encrypted Connection to SQL Server

Hello, can you please advise how I can set up an encrypted connection from PBI Desktop to SQL Server?

 

Currently I am getting the following error message. 

"The data source you're trying to access doesn't support encryption. To access this data source using an unencrypted connection, click OK."

 

I have looked through the following threads but could not find the right advice.

https://community.powerbi.com/t5/Desktop/Data-Source-encrypted/td-p/383240

https://community.powerbi.com/t5/Desktop/connect-to-SQL-DB-prompt-quot-The-data-source-you-re-trying...

https://community.powerbi.com/t5/Desktop/SQL-quot-We-couldn-t-authenticate-with-the-credentials-prov...

 

Power BI version: 2.62.5222.761 64-bit (September 2018)

Storage Mode: Direct Query

SQL Server version: Microsoft SQL Server Developer (64-bit) 13.0.1601.5

 

I followed this guide to configure database encryption: https://www.sqlshack.com/how-to-configure-transparent-data-encryption-tde-in-sql-server/

Do I need to also follow this guide to configure encrypted connections? https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-...

1 REPLY 1
Highlighted
cmaz Regular Visitor
Regular Visitor

Re: Configure Encrypted Connection to SQL Server

Hi !

 

 

I think it's worth trying that last link you shared.

 

Regards,

Cmaz