Forum Discussion
Helper VData ingestion from on prem sql to fabric
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/
Resolver IHello,
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?