Azure SQL Database
An Azure relational database service.
6,326 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.
Azure SQL Database
Accepted answer
-
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator2022-01-13T21:27:40.15+00:00
19 additional answers
Sort by: Most helpful
-
Tom Hovens 36 Reputation points
2022-01-13T18:51:28.33+00:00 Hi @Oury Ba-MSFT thanks for helping. But after changing the Connection Policy same result
-
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator2022-01-13T19:05:14.81+00:00 @Tom Hovens Could you please share the error message you are getting in SSMS and also how you are trying to login. Are you using SQL authentication, AAD password, AAD integrated ?
Regards,
Oury
Sign in to comment -
-
Tom Hovens 36 Reputation points
2022-01-13T19:20:36.03+00:00 @Oury Ba-MSFT . The left message keeps turning back.
-
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
2022-01-13T20:31:28.863+00:00 Hi Tom,
You are using tom.hovens@Microsoft Corporation .nl as a SQL Server Authenticalion login to connect to the Azure SQL database. Could you please use the SQL login you use to create the Azure SQL logical server?
Make a click on the server name.
Use the password you set fopr below login (server admin) and the login name to connect to Azure SQL database.
If you forgot the password, then change it on below screen
Hope this helps.
-
