Why would the prompt "Add my client IPv4 address" show an empty IP address?

Andrew Brown 40 Reputation points

When configuring a newly-created SQL Database server, the Networking page shows an empty IP address on the "Add your client IPv4 address" prompt.

See screenshot.

Is this a bug or evidence of hackers impersonating traffic?

User's image

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 23,937 Reputation points Microsoft Employee

    Hi @Andrew Brown

    We sincerely apologize for any inconvenience caused. thanks for bringing this to our attention, we were able to resolve the bug. The fix is included in the latest update, which was finalized today and is scheduled for a global release within the next 7-10 days.

    I hope this information helps. please let us know if you have any additional questions.



    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. Alberto Morillo 32,006 Reputation points MVP

    It is a bug, the same has been happening to me lately but it was working fine for years. It is not a security concern for you as user. You can use a site like whatismyip to get your current public IPv4 address.

    0 comments No comments

  2. Rahul Randive 5,656 Reputation points Microsoft Employee

    Hi @Andrew Brown

    Ideally "Add your client address" prompt on the Networking page of the Azure SQL Database server configuration is designed to automatically detect and display your current public IPv4 address.

    If it's showing as empty, I believe it could be due to current network configuration might be blocking the Azure portal from detecting your public IPv4 address or you might be using a VPN or proxy that probably hides your public IPv4 address.

    You can also try from the SQL Server management studio.

    If you're connecting to an Azure SQL Server, you might get prompted to sign in to create a firewall rule. Click Sign In...

    After successfully signing in, the form is pre-populated with your specific IP address.

    Reference document - https://learn.microsoft.com/en-us/sql/ssms/object/connect-to-an-instance-from-object-explorer?view=sql-server-ver16#connecting-to-a-server

    User's image

    Thank you!