Azure Fabric datawarehouse unable to write data to cloud SQL

Question

Hi,

Im trying to setting up Microsoft Fabric to write SQL data to Azure cloud SQL(private endpoints) by below approach.

Fabric --> Azure Firewall --> OPDG VM --> Azure SQL.

But im getting below error.

Note: OPDG is install in the cloud VM where i have added a default route 0.0.0.0/0 to Azure Firewall Private IP.

I believe im missing some DNAT or some other route to allow Inbound traffic from Microsoft Fabric to write SQL data to Azure cloud SQL

{

"copyDuration": 84,

"errors": [

	{

		"Code": 22300,

		"Message": "ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'XXXXXXXXXXXXXXXXXXXXXXXXXXXX.datawarehouse.fabric.microsoft.com', Database: 'e630392b-4caa-4c0d-a42f-412fb3e90ee7', User: ''. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.,Source=Microsoft.DataTransfer.Connectors.MSSQL,''Type=Microsoft.Data.SqlClient.SqlException,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: TCP Provider, error: 0 - The wait operation timed out.),Source=Framework Microsoft SqlClient Data Provider,''Type=System.ComponentModel.Win32Exception,Message=The wait operation timed out,Source=,'",

		"EventType": 0,

		"Category": 5,

		"Data": {},

Accepted Answer

@Mahesh - Thanks for the question and using MS Q&A platform.

Microsoft Fabric is currently not supported in the Q&A forums, the supported products are listed over here https://docs.microsoft.com/en-us/answers/products (more to be added later on).

Can you please open as a new thread in MS Fabric community: https://community.fabric.microsoft.com/t5/General-Discussion/bd-p/ac_generaldiscussion User's image

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Azure Fabric datawarehouse unable to write data to cloud SQL

0 additional answers

Your answer