Share via

Unable to connect Azure logic app(Standard) with System managed Identity to SQL Server

Sri t 0 Reputation points
2025-03-12T07:01:05.0066667+00:00

Hi Team,

We are Unable to connect Azure logic app(LA) standard with System managed Identity to SQL server. We tried to connect SQL using "LogicAppManagedIdentity" option, for that created new managed identity in LA workflow and used Execute Query V2 action. Also we created new server login with LA name and db access at SQL server & DB level.

Observations:

Auto population of SQL server name, database details are failed tried with manual entry of data on SQL execute Query (V2) connector.

Got below error while ran of LA
{ "error": { "code": 502, "source": "9160f72e23880745.03.common.logic-eastus2.azure-apihub.net", "clientRequestId": "f1facb45-ae73-4618-958d-fc9efd10c09a", "message": "BadGateway", "innerError": { "status": 502, "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.)\r\nclientRequestId: f1facb45-ae73-4618-958d-fc9efd10c09a", "error": { "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": "sql-eus2.azconn-eus2-002.p.azurewebsites.net" } } }

LA_community1.PNG

LA_community2.PNG

LA_community3.PNG

Regards

Sri

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,389 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Shireesha Eeraboina 2,065 Reputation points Microsoft External Staff
    2025-03-13T07:15:01.6333333+00:00

    Hi Sri t,

    Thank you for your patience and for sharing your feedback on the Q&A community platform. I’m glad to hear that you were able to resolve your issue, and I appreciate you sharing your solution! Your contribution is valuable and can help others in the community facing similar challenges.

    As per the Microsoft Q&A community policy, "The question author cannot accept their own answer. They can only accept answers by others"

    "The issue was resolved by utilizing Logic App (Standard) along with the built-in SQL connectors".

    If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue. 

    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.