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

Answer accepted by question author

Alberto Morillo 35,506 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.

Was this answer helpful?

1 person found this answer helpful.
0 comments

19 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Samuel Prince Chaane 6 Reputation points
    2022-04-22T22:23:02.327+00:00

    I solved it by:

    1. Options > Connect to Database [I added the name of the database]
    2. Redirect
      195741-image.png
    3. Add my client IP address
    4. Add my subnet IP address range
      195670-image.png

    Was this answer helpful?

    1 person found this answer helpful.
  2. Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator
    2022-01-11T22:10:20.46+00:00

    Please make sure you specify the database when you connect to Azure SQL.

    164008-image.png

    163967-image.png

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Tom Hovens 36 Reputation points
    2022-01-11T22:04:50.553+00:00

    Hi Alberto, thanks for replying. The IP Address returned by the site is already been added.

    Was this answer helpful?

    0 comments
  4. Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator
    2022-01-11T21:57:03.167+00:00

    Please make sure you are adding the correct client IP Address. Please add the IP Address returned by this site on Azure SQL Database firewall.

    Was this answer helpful?

    0 comments

Your answer

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