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

Question

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

Answer 1

Issue was resolved by going with Logic app (standard) and built-in SQL connectors.
https://learn.microsoft.com/en-us/azure/logic-apps/connectors/built-in/reference/sql/#actions