Forum Discussion

Rakuka's avatar
Rakuka
Frequent Visitor
3 months ago
Solved

Issue while trying to use an on-premises SQL Server source in Microsoft Fabric pipeline

Hi Fabric team, Good morning I am facing an issue while trying to use an on-premises SQL Server source in Microsoft Fabric through an on-premises data gateway.   Environment Fabric trial capacit...
Data Pipeline
  • v-tejrama's avatar
    v-tejrama
    3 months ago

    Hi Rakuka ,

     

    I would take a moment to thank Lodha_Jaydeep  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

    Thank you.

tayloramy's avatar
tayloramy
Super User
3 months ago

Hi Rakuka, 

 

If you open the gateway software and perform the network ports test, what is the result? 

 

  • Rakuka's avatar
    Rakuka
    Frequent Visitor
    3 months ago

    Hi tayloramy,
    Yes, I opened the on-premises data gateway software and ran the Network ports test.
    The result was 34/34 tests succeeded. The test also showed success for the Fabric-related endpoint ci.frontend.clouddatahub.net on port 443, and all listed gateway/service bus endpoints were returned as Open/Success. So based on the gateway diagnostics, there does not appear to be a firewall, outbound port, or general gateway network communication issue.
    Despite that, the SQL Server connection in Fabric still does not become fully usable in Copy activity.