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

Hi, I use my microsoft account. What do you mean by Microsoft Entra MFA? I was not given any option for that when I tried to connect to the Warehouse. If you mean the MFA in general for my microsoft account, then yes I have used that.

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

Hi ilalang_pertiwi, 

 

What tool are you connecting with? If you're trying to connect with SSMS, that's where you will see the Microsoft Entra MFA: 

 

In Power BI Desktop, if you connect using the Azure SQL database connector and the SQL Endpoint, the Microsoft account selection should be enough as long as you have permissions on the warehouse. 

 

In Power BI Desktop, you can also use the Onelake Catalog button to connect to the warehouse and create a directlake semantic model. 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

  • ilalang_pertiwi's avatar
    ilalang_pertiwi
    New Member
    10 months ago

    Oh I am trying to connect it with Data Warehouse in Microsoft Fabric

  • 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.