locked
SQL Server Authentication with Logic App is not working RRS feed

  • Question

  • 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

    Thursday, December 24, 2020 1:26 PM

All replies

  • forum migrated to mentioned below forum

    https://docs.microsoft.com/en-us/answers/index.html

    please mark as answer if issue resolve

    Friday, December 25, 2020 5:05 PM