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

Andrew Brown 40 Reputation points
2023-11-15T21:21:10.2166667+00:00

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 29,482 Reputation points Microsoft Employee
    2023-11-30T14:26:27.3466667+00:00

    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.

    Regards

    Geetha

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. Alberto Morillo 34,151 Reputation points MVP
    2023-11-15T22:11:44.87+00:00

    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. RahulRandive 9,901 Reputation points
    2023-11-16T22:03:09.0566667+00:00

    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!


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.