SQL server not Connecting in pipe line

[rajasekar_o]

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."

[v-yiruan-msft]

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