kudlatiger
Reputation: 3288
Why my client IP address shows different IP's every time?
I am on VPN and trying to connect Azure SQL server from SQL Management Studio
I get this popup, but IP on it keep changes.
Because of this, I see a lot of IP's getting added in Firewall settings of SQL Server in Azure portal
What is the solution here? Is it expected behaviour?
Upvotes: 1
Views: 1319
Answers (1)
Leon Yue
Reputation: 16431
I have the same environment that connect to the Azure SQL database via VPN connection. The client IP may changes every some days, I need to manually add the new IP to the firewall again manually. Just for now. I think that's caused by the VPN servers.Some suggestions are that keep your VPN address fixed. There isn't a good solution for now.
HTH.
Upvotes: 1
Related Questions
- Client with IP address is not allowed to access the server Azure SQL database
- IP Address of Azure SQL Server
- Allowing IP Address through SQL Server Firewall
- Azure DevOps/Pipeline IP is changing randomly so I can not use Azure SQL Database because of firewall rules
- How would I allow a C# Application to connect to an Azure SQL database without having to add the IP address to the firewall every time
- IP issues in Microsoft Azure
- Azure SQL Server Firewall IP address range
- Client IP address returns the same internal network address
- How can multiple clients connect to a Windows Azure SQL Database without adding firewall rules for each client IP address?
- Allowing multiple IP address connections to Windows Azure SQL Server