Answered

Connection to Azure SQL refused

(0) Share

Report

Posted on by manuelJoaquim

Hello,

I know this seems to be a already answered question, but I guess the problem could be more on Azure's SQL side. I created a SQL-Database on Azure and tried to connect with PowerApps. I get this error-message:

Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)
clientRequestId: XXX

Sitzungs-ID: XXX

I can access the Database from my computer, but only if I insert my IP in the firewall-settings. The option "Azure services connection allowed" is enabled.

I assume I do have to change something with the firewall? I did not change anything else regarding the firewall, everything is on default.

Thanks in advance!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI @manuelJoaquim ,

Could you please share a bit more about your error message?

I have made a test on my side, and don't have the issue that you mentioned. Please check if your client's IP address have access to your Azure SQL Server.

More details about connecting to Azure SQL Server from PowerApps, please check the following video:
https://www.youtube.com/watch?v=CO6xfbjnYwc

In addition, please also make sure that your network must not block these services required within PowerApps:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/limits-and-config#required-services

Please also check and see if the following article would help in your scenario:

https://guyinacube.com/2016/09/troubleshooting-connectivity-tips/

https://stackoverflow.com/questions/38694867/azure-error-a-network-related-or-instance-specific-error-occurred-while-establi

Best regards,
manuelJoaquim 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Well, as I said, I can access the database with my local machine. I even created a table and some roles within Azure. I inserted my IP within the firewall-settings and everything works from this part.
But, PowerApps just gives me the posted error message when I follow this instructions: Other solution

Is there something to configure from the PowerApps side? It seems to me that Azures firewall is blocking the cloud service.
This is a screenshot from Azure:
The normal SQL Database on a computer for databases. Sorry for the german interface, I can clarify more if this is needed.
Verified answer

manuelJoaquim 11 on at

Like
a
(0)

Report
Copy link

Link copied!

I found the solution.
I copied the URL again from the backend and got disposerver.database.windows.net. It worked now. Why?

The JSON I downloaded had disposerver.dataserver.windows.net. Why two URLs?! Seems to be the URL for the server which has the database stored. Wow.