Client IP Address does not have access SQL Server Management Studio

Question

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.

Answer 1

Change the authentication type please:

Thank you for your patience.

Answer 2

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.

Answer 3

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

Answer 4

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

Answer 5

Still no luck