topic Data ingestion from on prem sql to fabric in Dataflow

Data ingestion from on prem sql to fabric

sudhav — Thu, 13 Jul 2023 10:15:55 GMT

Hi Team,

I have installed gateways and trying to pull the data from my on premises sql server to fabric.

but i am facing below error. please look into it.

TIA

An exception occurred: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Session ID: c24f598b-b7f2-49fe-a5b8-36d0674efacb, Region: asia)

Re: Data ingestion from on prem sql to fabric

miguel — Thu, 13 Jul 2023 16:21:59 GMT

Hey!

This error is related to an SSL encryption configuration to a SQL data source. When and where exactly are you getting this error?

Re: Data ingestion from on prem sql to fabric

amolt — Tue, 03 Oct 2023 07:09:44 GMT

Hello,
I have exactly the same error. As far as I know, nothing has changed in the configuration.
I had updated the gateway in the morning, without any problem and several hours later, no more connection using OAuth 2.2 works. If I switch to "Windows" mode, no problem.
Gateway: 3000.190.19.0

I get the error when using connections in Gen2 dataflow and in connection management.
The gateway is online, nothing in the log.

Error message: "A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"

Any ideas?

Re: Data ingestion from on prem sql to fabric

amolt — Thu, 05 Oct 2023 14:44:38 GMT

I get the error when using connections in Gen2 dataflow and in connection management.
The gateway is online, nothing in the log.

Any ideas?

Re: Data ingestion from on prem sql to fabric

amolt — Wed, 11 Oct 2023 16:39:30 GMT

Hi sudhav

Have you solved your problem ?

Re: Data ingestion from on prem sql to fabric

Pragati11 — Tue, 17 Oct 2023 07:47:59 GMT

HI amolt ,

I actually did something similar few weeks back and got this working at my end and it is still working.

I ended up writing a blog including all the security settings I had to build on the SQL Server side specially. Just check my blog and let me know if it helps:

https://datavibe.co.uk/getting-on-premises-sql-server-data-to-fabric-lakehouse/

Re: Data ingestion from on prem sql to fabric

amolt — Mon, 23 Oct 2023 08:28:11 GMT

Hi Pragati11 ,

my problem is not accessing data on an On premise layer, but the use of Oauth2 which no longer works.
Thanks again for your reply.