Forum Discussion
Helper VData ingestion from on prem sql to fabric
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)
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/
6 Replies
- miguel
Community Admin
Hey!
This error is related to an SSL encryption configuration to a SQL data source. When and where exactly are you getting this error?
amoltResolver I
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.0I 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
Super User
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
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.0I 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?
