Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

0

Unable to connect to DataMart in service to reconnect/ create new Dataflows

We have a number of Dataflows which connect to a DataMart. The Dataflows have been working without too many issues so far for a number of months. This week, we needed to move a Dataflow to a different workspace (as part of a workspace consolidation) and have been unable to reconnect the Dataflow to the DataMart.

 

We have since tried recreating it from scratch as opposed to the JSON import, but we're also unable to connect any new Dataflows to our DataMart. We get the following 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)

Our other Dataflows that we have not gone into to either edit or move are still working without any issues so we're stumped and starting to think it's a wider infrastructure issue?

 

Any help would be greatly appreciated!

Status: Delivered
Comments
Anonymous
Not applicable

Hi @sarah127583 

So the newly created dataflow and datamart are not in the same workspace right? And then an error is reported when calling datamart's data?

 

Best Regards,
Community Support Team _ Ailsa Tao

sarah127583
Advocate I

Hi @Anonymous 

 

Correct - the Dataflows (both the orignal and new one) are in different workspaces to the DataMart. And we get the error when querying the DataMart - both using the SQL connector & DataMart connector

 

Many thanks, 
Sarah

sarah127583
Advocate I

Seems to have started working again now - just putting it down to DataMarts still being a bit buggy!

Anonymous
Not applicable

Hi @sarah127583 

Thanks for your feedback ! I will change the status to Delivered .

 

Best Regards,
Community Support Team _ Ailsa Tao