Data ingestion from on prem sql to fabric

[sudhav]

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)

[amolt]

Hi @sudhav 

Have you solved your problem ?

[amolt]

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?

[miguel]

Hey!

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

[amolt]

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?

[Pragati11 · Accepted solution]

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/

[amolt]

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.