Forum Discussion
trying to add pipeline using on prem sql server - getting azure sql error instead
- Anonymous10 months ago
Hi db042190 ,
The state may be disabled because you are using 3000.202.13 Version of the gateway,
You need an on-premises data gateway version 3000.214.2 or higher to support Fabric pipelines.
How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you
this is a bit of an education for me. I found this by navigating to admin powerplatform. I was surprised to see the same "on prem server" also being where the "gateway is installed" (do i have that right?). I looked inside the file to find "sqltrustedservers". It wasnt there. I was also surprised to see its online but not enabled as shown in the image. What does that mean, especially not enabled? I made a copy of the config file but will stop short of following the instructions till my network guys are on board with this. I'll see if i can learn somewhere how/where a node called sqltrustedservers would be added. its kind of weird to think the entry would basically be saying "trust myself" in terms of which servers are to be trusted. I'm also starting to wonder if a gw cluster is different from the gw itself and maybe i'm barking up the wrong tree. cluster sounds more like a failover thing.
sqltrustedservers is an entirely different topic (has to to with improper certificate management on your SQL server).