Share via

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
Accepted answer
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2022-01-13T21:27:40.15+00:00

    Change the authentication type please:

    164914-image.png

    Thank you for your patience.

    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 34,671 Reputation points MVP Volunteer Moderator
    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?

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.