[SOLVED] Cannot connect to SQL Server from logic app

Cannot connect to SQL Server from logic app

I'm having trouble connecting to my SQL Server in an Azure Logic App.

I've just created a fresh SQL Server and database and am now attempting to connect to it in my logic app. However, it doesn't appear to be showing when I enter my credentials. I've been following this tutorial.

Does anyone know why this might be the case? Is it perhaps a permission thing that I may have missed?

I've also found that if i do an AD connection, I get this:

Solution

Try this for connecting to your DB:

first of all, try to connect with Azure AD Integrated here, and if you don't see your SQL Server and DB in the list try the next step
go to Resource Group where you created LogicApp and find the connection name that you used when trying to connect with Azure AD Integrated. You need to open it and click on Edit API Connection. In Authentication Type use SQL Server Authentication and other data to connect to your DB here.