Can I connect powerapps with an SQL Server database hosted on Azure that is still in a free trial period, or do I need to upgrade to pay as you go?

Ben Terrell 1 Reputation point
2021-10-26T13:52:39.893+00:00

I have created and populated an SQL database and am now trying to link it to Powerapps with no success. One question I would like to rule out is whether the problem is linked to the fact that the Azure account is still in the 30 day free trial period. To put it more clearly, can I connect powerapps with an SQL Server database hosted on Azure that is still in a free trial period, or do I need to upgrade to pay as you go?

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
    2021-10-26T22:29:01.07+00:00

    Hi @Ben Terrell Thank you for posting your Question on Microsoft Q&A.

    You can create a PowerApp in Azure portal and link it to your Azure SQL Database with your free account unless you have used all your free credits before the 30 days.
    I was able to repro this with my free trial .

    143897-image.png

    143954-image.png

    You can configure Power Apps access to Azure SQL Database server using the Azure portal, or stored procedure sp_set_firewall_rule.
    Please also make sure that you select Firewalls and virtual networks and set the control Allow Azure services and resources to access this server to ON. Select Save to submit changes.

    You can also use stored procedure sp_set_firewall_rule with IP address 0.0.0.0 to allow Azure services access to your SQL Database server.

    This can also be achieved using CLI

    Please share the error message you are seeing.

    Regards,
    Oury