topic Re: The server was not found or was not accessible. in Data Warehouse

The server was not found or was not accessible.

ramiro_gonzalez — Mon, 25 Nov 2024 13:36:35 GMT

Suddenly, when refreshing the dataflow that loads data into a warehouse, I get the following error. It won’t let me load tables into the warehouse and says it can’t connect to the SQL Server instance of the warehouse.

Does this happen to anyone else? Do you know this error? Thanks so much for your help!

ERROR:

Estudio_WriteToDataDestination: There was a problem refreshing the dataflow: 'Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Details: Reason = DataSource.Error;ErrorCode = 10478;DataSourceKind = Warehouse;DataSourcePath = Warehouse;DataSourceKind.2 = SQL;DataSourcePath.2 = *********.fabric.microsoft.com;Data Warehouse;Message = A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server);ErrorCode = -2146232060;Number = 53;Class = 20;State = 0;Microsoft.Data.Mashup.Error.Context = User'. Error code: Mashup Exception Data Source Error. (Request ID: f0868393-3015-46b0-bcf0-95083000d7ca).

Re: The server was not found or was not accessible.

AdeV-Oly — Mon, 25 Nov 2024 15:08:01 GMT

Same issues as of today. Dataflows worked fine before the weekend.

Re: The server was not found or was not accessible.

Anonymous — Mon, 25 Nov 2024 15:14:50 GMT

Same for us. We opened a Ticket with MS. I suggest you do the same. The more support tickets we open the faster we will get support from MS.

Re: The server was not found or was not accessible.

AdeV-Oly — Mon, 25 Nov 2024 15:39:21 GMT

Temporary solution: click on 'Refresh now'. Might take an attempt or two.

Re: The server was not found or was not accessible.

Timbaaaal — Mon, 25 Nov 2024 16:21:04 GMT

Same issue, all my dataflow gen 2 pulling data from and to Lakehouse/Warehouse are failing.. everything was working fine before today.

3rd time in approx 4 month that I have dataflow gen 2 getting major outage for 24h+ in production workspace, without even clear communication from Microsoft. This really make me secound thought my move from PPU to Fabric.. clearly cannot have critical solution depending on this.

Re: The server was not found or was not accessible.

robertostaino — Mon, 25 Nov 2024 17:25:12 GMT

Same issue, lemme know if you find a solution.

Re: The server was not found or was not accessible.

ecaldwell — Mon, 25 Nov 2024 17:40:55 GMT

Same issue!!

Re: The server was not found or was not accessible.

coverturfLSH — Mon, 25 Nov 2024 17:53:38 GMT

Having the same issue trying to refresh a desktop powerBI file pulling from a Fabric warehouse.

Re: The server was not found or was not accessible.

belkov78 — Mon, 25 Nov 2024 19:32:21 GMT

Same for me; in 4 different workspaces in our company, dataflows with more than a couple of queries will fail miserably and on seperate steps with the same error.

Very frustrating.

Re: The server was not found or was not accessible.

CSF — Mon, 25 Nov 2024 20:25:10 GMT

I have the same errors today on my dataflows to Data Warehouse in Fabric. I can't find the cause. I had this same problem on October 20th I believe. All day, I could find no cause and everything worked as usual the next day.

This could be related... Microsoft 365 down? Current problems and outages | Downdetector

Re: The server was not found or was not accessible.

Timbaaaal — Mon, 25 Nov 2024 21:12:49 GMT

Microsoft just updated their status page
https://support.fabric.microsoft.com/en/support//

Service Outage/Degradation

Fabric customers may experience issues with Dataflow Gen2 refreshes. Engineers are investigating the issue, and an update will be provided soon.

Re: The server was not found or was not accessible.

mesallam — Mon, 25 Nov 2024 23:28:19 GMT

same issue!

Re: The server was not found or was not accessible.

Timbaaaal — Tue, 26 Nov 2024 07:48:53 GMT

Looks like its fix now.

Re: The server was not found or was not accessible.

belkov78 — Tue, 26 Nov 2024 07:50:23 GMT

Yes, it looks like everything is back to normal indeed.

topic Re: The server was not found or was not accessible. in Data Warehouse

The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Microsoft just updated their status pagehttps://support.fabric.microsoft.com/en/support//Service Outage/Degradation

Re: The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Re: The server was not found or was not accessible.

Microsoft just updated their status page
https://support.fabric.microsoft.com/en/support//

Service Outage/Degradation