Azure SQL Database
An Azure relational database service.
5,085 questions
Change the authentication type please:
Thank you for your patience.
Client IP Address does not have access SQL Server Management Studio
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 46%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Tom Hovens
36
Reputation points
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.
Accepted answer
19 additional answers
Sort by: Most helpful
-
Alberto Morillo 32,796 Reputation points MVP2022-01-11T22:10:20.46+00:00 Please make sure you specify the database when you connect to Azure SQL.
-
Samuel Prince Chaane 6 Reputation points2022-04-22T22:23:02.327+00:00 I solved it by:
- Options > Connect to Database [I added the name of the database]
- Redirect
- Add my client IP address
- Add my subnet IP address range
-
Samuel Prince Chaane 6 Reputation points
2022-04-22T22:38:10.66+00:00 Success
-
Alberto Morillo 32,796 Reputation points MVP
2022-04-22T22:44:02.83+00:00 Thank you Samuel for adding your solution to the same issue/problem.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 33%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
michael daniel 1 Reputation point2023-01-04T10:14:41.343+00:00 Thanks a bunch @Samuel Prince Chaane worked for me too!!
Sign in to comment -
Alberto Morillo 32,796 Reputation points MVP
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.
-
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.