Error while Trying to connect Fabric Warehouse

[ilalang_pertiwi]

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: SSL Provider, error: 0 - The specified network name is no longer available.)". If someone can tell me what does "network name" here refer to? I am so confused as I use both my PBI Desktop and the service with my work email. Any help would be appreciated, thank you.

[ilalang_pertiwi]

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: SSL Provider, error: 0 - The specified network name is no longer available.)". If someone can tell me what does "network name" here refer to? I am so confused as I use both my PBI Desktop and the service with my work email. Any help would be appreciated, thank you.

[tayloramy]

Hi @ilalang_pertiwi, 

What auth method are you using? To connect to the SQL endpoint, you will need to use Microsoft Entra MFA. 

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

[vivien57]

Hello @ilalang_pertiwi ,

You are not in the right forum, you can re-create your post here : 

https://community.fabric.microsoft.com/t5/Data-Warehouse/bd-p/ac_datawarehouse

you are in the Power BI On-Premise forum (Warehouses do not exist On-Premise)

Have a nice day,

Vivien

[tayloramy]

Hi @ilalang_pertiwi, 

what auth method are you using when connecting? To connect, you need to use Microsoft Entra MFA  

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]

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]

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]

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

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

The specified network name is no longer available

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

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

[tayloramy]

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

[ilalang_pertiwi]

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

[tayloramy]

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

[ilalang_pertiwi]

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

[tayloramy · Accepted solution]

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?  

[v-menakakota]

Hi @ilalang_pertiwi ,

Can you please confirm whether the issue is sorted or not. 

Thank you.

[v-menakakota]

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]

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