Forum Discussion
SQL server not Connecting in pipe line
hi team
i try to connect Sql server in fabric pipeline copy data to lake house but it show error.
"We were unable to connect to the data source using an encrypted connection. To use an unencrypted connection, uncheck "Use encrypted connection" and try again."
1 Reply
Hi rajasekar_o ,
It seems to be unable to establish the encrypted connection when Power BI attempt to use an encrypted connection to SQL Server data source. Could you please check the following info?
- Ensure that the SQL Server is configured to support encrypted connections
- Ensure SQL Server have the appropriate TLS/SSL certificates installed or configured properly: Securing connections to SQL Server with TLS
In addition, the following link is the thread which has the similar problem as yours. Hope its solution can help you solve your problem.
Solved: unable to connect to the data source using an encr... - Microsoft Fabric Community
Best Regards
