GatewayTimeout Error When Creating Azure SQL Connection in Logic Apps

Question

GatewayTimeout Error When Creating Azure SQL Connection in Logic Apps

Buchammagarivikram Reddy 40

Hi everyone,

I'm trying to create an Azure SQL connection within Azure Logic Apps. The SQL database is deployed in the same Azure tenant, and I'm using SQL Server authentication. I've double-checked that the server name, database name, username, and password are all correct.

However, I'm consistently getting the following error:

Failed to create connection: {"error":{"code":"GatewayTimeout","message":"The gateway did not receive a response from 'Microsoft.Web' within the specified time period."}}

Since this is an Azure SQL Database (not on-premises), I assume a data gateway shouldn't be required. Has anyone encountered this issue before or know what might be causing it?

Any help or guidance would be greatly appreciated!

Thanks in advance.

User's image

Krishna Chowdary Paricharla 655 Reputation points Microsoft External Staff Moderator

2025-07-07T12:03:43.4866667+00:00
Hello Buchammagarivikram Reddy,

Could you please provide more details about your setup. Here are some follow-up questions that could help narrow down the issue:

Are you using any custom connectors or the built-in SQL connector in Logic Apps?

Have you tried connecting from a different Logic App or resource to see if the issue is specific to the current setup?

What is the exact timeout value set for your Logic App connection?
Buchammagarivikram Reddy 40 Reputation points

2025-07-07T13:39:11.6166667+00:00
Hi Krishna,

Thanks for your response. Please find below the clarifications you requested:

Are you using any custom connectors or the built-in SQL connector in Logic Apps?

We are using the out of the box Azure Logic Apps SQL connector, not a custom one.

Have you tried connecting from a different Logic App or resource to see if the issue is specific to the current setup?

The issue is not specific to a particular Logic App. We are unable to establish a connection with the Azure SQL Managed Instance across the board.

We are using SQL Server authentication, and all credentials have been verified as correct. Additionally, we are unable to connect to the same SQL Managed Instance via SSMS.

We would like to understand what settings or configurations are required on the Azure SQL Managed Instance to allow connections from applications like Azure Logic Apps (Consumption-based) and SSMS.

For testing purposes, we have made the SQL Managed Instance public, but the connection still fails.

Is there a limitation that prevents Consumption-based Logic Apps from connecting to Azure SQL Managed Instances?

What is the exact timeout value set for your Logic App connection?

The timeout value is set to 30 seconds.
Buchammagarivikram Reddy 40 Reputation points

2025-07-09T07:34:37.1466667+00:00

Hi Krishna,

I spoke with our infrastructure team, and it looks like the issue isn’t with Logic Apps—it’s related to how the SQL Managed Instance was set up. The problem lies in the networking configuration, which is currently preventing a successful connection to SQL.

We’re working on whitelisting the IP addresses for Azure Logic Apps in the region, and hopefully that resolves the issue. I’ll share an update once this is completed.
Buchammagarivikram Reddy 40 Reputation points

2025-07-10T08:23:59.8666667+00:00

Hi All,

Here is what we have done to resolve the issue.

Connectivity between consumption-based Azure Logic Apps and the locked-down SQL Managed Instance (SQL MI) has been successfully established in the non-prod environment.

As per Microsoft documentation, consumption-based Logic Apps require a data gateway resource to connect to SQL Server—even when hosted in Azure. To meet this requirement, a data gateway server was deployed within the same virtual network (VNet) as the SQL MI.

We have tested the connection and it is functioning as expected.

This setup aligns with Microsoft's recommended architecture for SQL Server authentication in Logic Apps.

Connect to SQL Databases from Workflows - Azure Logic Apps | Microsoft Learn

Accepted answer

0 additional answers

Your answer

Krishna Chowdary Paricharla 655 Reputation points Microsoft External Staff Moderator

2025-07-07T12:03:43.4866667+00:00

Hello Buchammagarivikram Reddy,

Could you please provide more details about your setup. Here are some follow-up questions that could help narrow down the issue:

Are you using any custom connectors or the built-in SQL connector in Logic Apps?

Have you tried connecting from a different Logic App or resource to see if the issue is specific to the current setup?

What is the exact timeout value set for your Logic App connection?
Buchammagarivikram Reddy 40 Reputation points

2025-07-07T13:39:11.6166667+00:00

Hi Krishna,

Thanks for your response. Please find below the clarifications you requested:

Are you using any custom connectors or the built-in SQL connector in Logic Apps?

We are using the out of the box Azure Logic Apps SQL connector, not a custom one.

Have you tried connecting from a different Logic App or resource to see if the issue is specific to the current setup?

The issue is not specific to a particular Logic App. We are unable to establish a connection with the Azure SQL Managed Instance across the board.

We are using SQL Server authentication, and all credentials have been verified as correct. Additionally, we are unable to connect to the same SQL Managed Instance via SSMS.

We would like to understand what settings or configurations are required on the Azure SQL Managed Instance to allow connections from applications like Azure Logic Apps (Consumption-based) and SSMS.

For testing purposes, we have made the SQL Managed Instance public, but the connection still fails.

Is there a limitation that prevents Consumption-based Logic Apps from connecting to Azure SQL Managed Instances?

What is the exact timeout value set for your Logic App connection?

The timeout value is set to 30 seconds.
Buchammagarivikram Reddy 40 Reputation points

2025-07-09T07:34:37.1466667+00:00

Hi Krishna,

I spoke with our infrastructure team, and it looks like the issue isn’t with Logic Apps—it’s related to how the SQL Managed Instance was set up. The problem lies in the networking configuration, which is currently preventing a successful connection to SQL.

We’re working on whitelisting the IP addresses for Azure Logic Apps in the region, and hopefully that resolves the issue. I’ll share an update once this is completed.
Buchammagarivikram Reddy 40 Reputation points

2025-07-10T08:23:59.8666667+00:00

Hi All,

Here is what we have done to resolve the issue.

Connectivity between consumption-based Azure Logic Apps and the locked-down SQL Managed Instance (SQL MI) has been successfully established in the non-prod environment.

As per Microsoft documentation, consumption-based Logic Apps require a data gateway resource to connect to SQL Server—even when hosted in Azure. To meet this requirement, a data gateway server was deployed within the same virtual network (VNet) as the SQL MI.

We have tested the connection and it is functioning as expected.

This setup aligns with Microsoft's recommended architecture for SQL Server authentication in Logic Apps.

Connect to SQL Databases from Workflows - Azure Logic Apps | Microsoft Learn

Answer 1

Hello Buchammagarivikram Reddy •,

Issue: The user encountered a "GatewayTimeout" error while creating an Azure SQL connection in a consumption-based Logic App using SQL Server authentication, even though the SQL database was hosted in Azure (not on-premises). This led to confusion about whether a data gateway was required.

Root Cause: Consumption-based Logic Apps require a data gateway to connect to SQL Managed Instance (SQL MI), even if it's hosted in Azure, due to the underlying network restrictions and integration runtime behavior.

Solution: To resolve this, a data gateway server was deployed in the same VNet as the SQL MI. Once in place, the Logic App was able to successfully establish connectivity to the SQL MI. This solution follows Microsoft’s recommended architecture.

Reference: Connect to SQL Databases from Workflows - Azure Logic Apps | Microsoft Learn

Share via

GatewayTimeout Error When Creating Azure SQL Connection in Logic Apps

0 additional answers

Your answer