Cannot connect to SQL Server from logic app

Question

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:

Answer 1

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.

Answer 2

Make sure you are allowing azure services to access your database server at

SQL Server > Firewalls and virtual networks > Allow Azure services and resources to access this server = Yes