Answered

SQL Server Connection Issue

(0) Share

Report

Posted on by murad_musleh

Hi everyone,

I have an on-premise SQL server, and when trying to create a PowerApps connection, I encountered an error related to the SSL certificate. How can I resolve this issue?

error in the attachment

Categories:

Power Apps Pro Dev & ISV

SQL Connection Er...

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nandit 1,568 Moderator on at

Like (0)

Report

Hi murad_musleh,

I am not sure if you came across this Reddit post which talks about the issue you're facing. Apparently it has helped a few developers who were facing the same issue - https://www.reddit.com/r/PowerBI/comments/1bd0yl9/error_when_connecting_via_sql_connection/

Hope it helps you too.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
murad_musleh 4 on at

Like (0)

Report

Hi @nandit

Thanks for your help. It was related to On-Premise Data gateway. I changed the settings in Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config by setting the value of SqlTrustedServers to my server name.

Thanks again

Was this reply helpful? Yes No