This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 17%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFU%3C/text%3E%3C/svg%3E)
Hello, I am working on a WPF desktop application. I created an Azure SQL database as a database. However, the connection constantly fails because the IP address changes constantly with the connection sentence I set through the application. What settings do I need to make to connect to the database? Thank you.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
I assume you mean the azure firewall is blocking. If you know the ip range of the users you can add the range. Otherwise you need to really open to any ipaddress (not a good idea).
you may also want look at a private vpn or application gateway.
a better design is for azure to host a webapi to the Sqlserver that the desktop app uses.
hello, I couldn't quite understand what the appropriate method is for accessing this database from a desktop application. I have just started experimenting with the Azure system. Could you help me in more detail on this matter?
Thank you.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
@fatih uyanık
Thank you for the question and for using Microsoft Q&A platform.
It seems like you are having trouble connecting to your Azure SQL Database from your WPF desktop application due to the constantly changing IP address. One possible solution is to allow access to Azure services in the firewall settings of your Azure SQL Database server. This will allow your WPF desktop application to connect to the database without specifying a fixed IP address.
To do this, you can follow these steps:
Instead of allowing individual IP addresses, you can configure a range of IP addresses. This way, even if your IP changes within this range, the connection will still be allowed. You can set this up in the Azure portal under your SQL Database’s firewall settings.
1.Go to the Azure portal and navigate to your Azure SQL Database server.
2.Click on "Networking" under the "Security" section.
3.Under the "Firewall settings" tab, you can select the desired IP address range.
4.Click "Save" to apply the changes.
Once you have made these changes, your WPF desktop application should be able to connect to the Azure SQL Database without specifying a fixed IP address.
https://www.sqlshack.com/configure-ip-firewall-rules-for-azure-sql-databases/
https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql
https://learn.microsoft.com/en-us/azure/azure-sql/database/secure-database-tutorial?view=azuresql
Hope this helps. Please let us know if you have any further questions.
@fatih uyanık
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.