Forum Discussion

DiegoPLAB's avatar
DiegoPLAB
Icon for Advocate I rankAdvocate I
1 year ago
Solved

On-premises gateway issue

Good morning, in our trial subscription we face an issue using on-prem gateway to ingest data from a local SQL Server instance. We built a pipeline with a Copy Data activity, that connects to our o...
data engineering
  • DiegoPLAB's avatar
    DiegoPLAB
    1 year ago

    Good morning,

    the Microsoft support team suggested us to downgrade the gateway to an older version (October 2024).
    With that version, we didn't faced the 9518 error anymore.

v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
1 year ago

Hi DiegoPLAB ,

We really appreciate your efforts and for letting us know the update on the issue.
Make sure the linked service for the SQL Server source is using the correct self-hosted integration runtime (matching the gateway you have installed).
If you're copying multiple tables in a single activity or pipeline, consider breaking it down into smaller parts to reduce resource demand.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Best Regards, 
Menaka.
Community Support Team  

DiegoPLAB's avatar
DiegoPLAB
Icon for Advocate I rankAdvocate I
1 year ago

Hi v-menakakota,

we don't think it's a resource consumption problem in our capacity, as you can see above in the reply to Srisakthi.

In that reply, you can see the exact error message. Everithing appears to be correctly configured and active/online (both gateway and connection) in the Fabric connections page. But when we test the connection inside an activity, the test fails with error 9518.