Client IP Address does not have access SQL Server Management Studio

Tom Hovens 36 Reputation points
2022-01-11T21:14:52.197+00:00

Hi,

When trying to log on to my server I get the error "Your client IP address does not have access to the server. Sign in to an Azure Account and create a new firewall rule enable access." After adding the my client address to the Firewall rules the same error popups. When I look in Azure at the firewall setting I see several rows of rules, all with the same ip addresses. I also add the client ip address but no luck. What do I need to change in setting so I can open my database with SSMS.

Azure SQL Database
0 comments

19 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Hovens 36 Reputation points
    2022-01-13T21:29:02.093+00:00

    Yeah.....finally....some many thanks.

    0 comments
  2. Alberto Morillo 32,891 Reputation points MVP
    2022-01-13T21:30:09.437+00:00

    Oh my God. Thank you for your patience with me. I am sorry it took me so much time.

    0 comments
  3. Lucas Depetris 0 Reputation points
    2023-11-13T04:29:04.0566667+00:00

    Sorry, I'm having the same issue. How did you solve it?