question

BenTerrell-2889 avatar image
0 Votes"
BenTerrell-2889 asked OuryBa-MSFT commented

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?

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
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.

1 Answer

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT commented

Hi @BenTerrell-2889 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



image.png (49.5 KiB)
image.png (24.1 KiB)
· 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 @BenTerrell-2889 Were you able to check and follow instructions in the above answer I posted. Please do not forget to mark as accepted if the information above was helpful.

Regards,
Oury

0 Votes 0 ·

Hi @BenTerrell-2889 Were you able to check and follow instructions in the above answer I posted. Please do not forget to mark as accepted if the information above was helpful.

Regards,
Oury

0 Votes 0 ·