question

Monty-7685 avatar image
0 Votes"
Monty-7685 asked SrivathsanS-8992 answered

Cant connect to Azure SQL from Logic App, but can from SSMS

Hi everyone
MS Support suggested I post here to get this issue resolved

I have set up a SQL database in Azure. I can connect to it from SSMS without issue.
When I try to use a logic app to connect to the same DB to run a stored proc, it says credentials are wrong

I cant for the life of me figure out why.

any ideas?

azure-sql-databaseazure-logic-apps
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Monty-7685, welcome to Microsoft Q&A forum.

Could you please tell us what was the authentication type used to connect to azure Sql database and also was the firewall configured?

In case, you can provide the screenshot of logic add designer along with error message, this would help to replicate the exact scenario.



0 Votes 0 ·

@Monty-7685 Could you please check if the firewall is configured to "Allow Azure services and resources to access this server"

35715-image.png


0 Votes 0 ·
image.png (63.8 KiB)

1 Answer

SrivathsanS-8992 avatar image
0 Votes"
SrivathsanS-8992 answered

177573-image.png



image.png (208.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.