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?  

ilalang_pertiwi's avatar
ilalang_pertiwi
New Member
10 months ago

I tried to open the Warehouse in SSMS, and use Microsoft Enfra MFA as you advised. And it still gives me the same error.

TITLE: Connect to Server
------------------------------

Cannot connect to fxjoxeu4bileljupxklgqu5i6m-b5vuya6is77url7nhwwsujfe64.datawarehouse.fabric.microsoft.com.

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-64-database-engine-error

------------------------------

The specified network name is no longer available

------------------------------
BUTTONS:

OK
------------------------------

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