I am trying to connect Power Automate to my Azure based SQL Server. When I try to create a new connection via the SQL Server connector, the option to select Azure AD as an authentication method is missing. Would anyone know why, and what i can do to add it?
I am trying to connect Power Automate to my Azure based SQL Server. When I try to create a new connection via the SQL Server connector, the option to select Azure AD as an authentication method is missing. Would anyone know why, and what i can do to add it?
Share Improve this question asked Jan 21 at 11:50 Mike82Mike82 13 bronze badges 1- Please provide enough code so others can better understand or reproduce the problem. – Community Bot Commented Jan 22 at 4:08
1 Answer
Reset to default 0In order to establish a connection to Azure SQL Server using Azure Entra ID, you can select Authentication type either as Service Principal (Microsoft Entra ID application) or Microsoft Entra ID Integrated.
In this way, you can create a connection to Azure SQL server for further interaction.