Sql Azure Server wont let me reset password

James Weatherhead 20 Reputation points
2024-03-13T16:07:50.13+00:00

When i try to reset my password it tells me Failed to overwrite server firewall rules and refresh blade. This was working perfectly fine a few weeks ago, now i cannot even attempt to reset the admin password. Has anyone else had this issue?

Thanks!

User's image

Azure SQL Database
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 27,002 Reputation points Microsoft Employee
    2024-03-13T22:22:35.5866667+00:00

    @James Weatherhead I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

    Issue:unable to reset the admin password for your SQL Azure server. you are receiving an error message "Failed to overwrite server firewall rules and refresh blade

    Solution: As you mentioned It turns out that Microsoft has stopped Classic Administrator from having true admin access despite the email stating that it is valid until August 2024. I had to go into the IAM blade in Azure Sql Server and add the RBAC roles "Owner" and "SQL Security Manager". Once added i opened a new browser windows in private mode, logged in and i can now reset the admin password.

    If you have any other questions or are still running into more issues, please let me know. Thank you again for your time and patience throughout this issue.

    Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

    Regards

    Geetha


2 additional answers

Sort by: Most helpful
  1. Rahul Randive 8,021 Reputation points Microsoft Employee
    2024-03-13T17:21:46.87+00:00

    Hi @James Weatherhead

    Have you tried to rest the admin account password using CLI or PowerShell command.

    Here is the blog and commends.

    https://techcommunity.microsoft.com/t5/azure-database-support-blog/reset-lost-admin-account-password/ba-p/368920

    Please try. Hopefully it should work. If it gets failed, please share the error message.

    Thank You!


  2. James Weatherhead 20 Reputation points
    2024-03-13T19:48:43.1933333+00:00

    Found the solution...

    It turns out that Microsoft has stopped Classic Administrator from having true admin access despite the email stating that it is valid until August 2024. I had to go into the IAM blade in Azure Sql Server and add the RBAC roles "Owner" and "SQL Security Manager". Once added i opened a new browser windows in private mode, logged in and i can now reset the admin password.

    0 comments No comments