Forum Discussion

ilalang_pertiwi's avatar
ilalang_pertiwi
New Member
10 months ago
Solved

Error while Trying to connect Fabric Warehouse

Hi all,   I have been trying to connect to Fabric Warehouse but it always give me this error message. I could not find the exact same error in this community, with exact same error of "(provider: S...
data warehouse
warehouse
  • tayloramy's avatar
    tayloramy
    10 months ago

    Hi ilalang_pertiwi, 

    By default the block outbound and inbound workspace settings are disabled, so those shouldn't be the problem. 

    Are you having this issue with one sepcific warehouse, or every wharehouse you try to connect to?  

tayloramy's avatar
tayloramy
Icon for Super User rankSuper User
10 months ago

Can you verify that the SQL endpoint is still active and you have permissions on the warehouse? 

ilalang_pertiwi's avatar
ilalang_pertiwi
New Member
10 months ago

Yes, its still active. I was the one who created the warehouse. And i just created it today.

  • tayloramy's avatar
    tayloramy
    Icon for Super User rankSuper User
    10 months ago

    Hi ilalang_pertiwi, 

     

    Last thought, is port TCP 1433 open on your device? Does your company's firewall block it by chance? 

     

    You can test this in Powershell with this command: 

    Test-NetConnection -ComputerName <your-warehouse-server> -Port 1433
    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      10 months ago

      Hi ilalang_pertiwi ,
      Thanks for reaching out to the Microsoft fabric community forum. 

       

      I would also take a moment to thank tayloramy   , 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 hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

       

       

      Best Regards, 
      Community Support Team  

    • ilalang_pertiwi's avatar
      ilalang_pertiwi
      New Member
      10 months ago

      Hi the firewall seems fine, the output is TRUE. I was wondering if it's something to do with this setting?

       

      • tayloramy's avatar
        tayloramy
        Icon for Super User rankSuper User
        10 months ago

        Hi ilalang_pertiwi, 

        By default the block outbound and inbound workspace settings are disabled, so those shouldn't be the problem. 

        Are you having this issue with one sepcific warehouse, or every wharehouse you try to connect to?