Share via

Deploying Azure SQL API Connection for Logic App using ARM

Morne Weyers 10 Reputation points
2024-05-07T17:06:06.31+00:00

I have successfully created an Azure SQL Connection and registered it in the Logic App. However, I would like to authorize the connection manually, similar to creating a connection to one of the O365 services. When I create the Azure SQL Connection and want to edit the API, I only see empty fields to enter like Authentication Type, Username, Password, Database. Is there a way to deploy the ARM template that will allow me to authorize the connection using my EntraID?

Azure SQL Database
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,924 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,062 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. akinbade abiola 4,210 Reputation points
    2024-05-07T19:01:52.8033333+00:00

    Hello Morne Weyers

    Thanks for your question.

    You can use Entra ID only authentication as described here.

    https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-create-server?view=azuresql&tabs=arm-template#azure-sql-database

    However pls note, you need to add it to your sql and Assign the necessary database roles to the Azure AD user for appropriate access.:

    e.g *CREATE USER [Your-UserName] FROM EXTERNAL PROVIDER;
    *
    If manual authorization is necessary, consider configuring this within the Azure portal after the initial deployment, once the connection is set up in the ARM template, no further interactive authorization should be necessary.

    Please let me know if you have further questions

    You can mark it 'Accept Answer' if this helped.

    0 comments