I am trying to connect to Azure SQL Database through Logic App, but I continue to get below error -
Please check your account info and/or permissions and try again. Details: Microsoft SQL: Cannot open server 'hrmanagementserver' requested by the login. Client with IP address '[IP Address]' is not allowed to access the server.
To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect. clientRequestId: 4DCE8EA9-041C-4AFC-A3B0-A3BC0AAFBD46.
Client request id: '4DCE8EA9-041C-4AFC-A3B0-A3BC0AAFBD46'
I am able to connect to same SQL Server through portal, SSMS and .Net application.I have already added the client IP in firewall configuration as well