Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
HaraldK
New Member

Connection to SQL via Data Gateway fails: Error occurred while decoding OAEP padding.

Get this error when trying to connect to our SQL Server on-premis using enterprise data gateway, and when using File option.

 

Unable to connect: We encountered an error while trying to connect to SQLServer. Details: "There was an error in the data gateway."Hide details

  
Status code:400
Error Code:DM_GWPipeline_UnknownError
Time:Thu Aug 24 2017 13:28:47 GMT+0200 (Central Europe Daylight Time)
Version:13.0.2136.181
Underlying error message:Error occurred while decoding OAEP padding.
DM_ErrorDetailNameCode_UnderlyingHResult:-2146233296

 

I connect with windows credentials, credentials are working from the Data Gateway server, 

I installed the gateway to days ago, should be the latest version.

 

Any ide why this message is happening? I found something on the community, a suggestion to replace the msolap.dll file, however the file is not longer accessible from the forum.

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

@HaraldK,

Do you use "File" data source type in Gateway to add the SQL Server data source? If so, when adding SQL Server data source within gateway, we need to choose "SQL Server" type, please follow the guide in this article to perform the process.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
poncoy
Frequent Visitor

Hello. You use the Personal Gateway or the Enterprise Gateway?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors