cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
manuelJoaquim
Level: Powered On

Connection to Azure SQL refused

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!

1 ACCEPTED SOLUTION

Accepted Solutions
manuelJoaquim
Level: Powered On

Re: Connection to Azure SQL refused

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.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Connection to Azure SQL refused

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

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
manuelJoaquim
Level: Powered On

Re: Connection to Azure SQL refused

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

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:
screen04.jpg

The normal SQL Database on a computer for databases. Sorry for the german interface, I can clarify more if this is needed.

manuelJoaquim
Level: Powered On

Re: Connection to Azure SQL refused

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.

View solution in original post

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (7,938)