Resetting an Azure SQL Database Admin Password

This is likely something that most people know, but it was a bit confusing for me. This post is really here to remind me and help cement this in my mind.

I went to connect to a QA database that I don’t use very often, and for some reason, I couldn’t remember the password. I tried a number of them, but none worked. Not the best situation to find yourself in.

I then decided to just reset the password and went to the database Overview. This is what I saw:

2019-11-26 17_53_06-Sandbox (dkranchapps_Sandbox) - Microsoft Azure

I could have sworn there was a “Reset” option here. I even tried searching a few places and there were people that mentioned there being a reset. Why wasn’t I seeing one?

Because I was in the wrong place. Reading closer a post on the Tech Community, I see that I need to be in the SQL Server server blade, not the database.

Once I realized that, I clicked over to that spot in the portal. Looking at my SQL Server, and I see the Reset.

2019-11-26 17_56_42-dkranchstaging - Microsoft Azure

Slightly confusing, and certainly something I hope I remember from here, but if a new developer is working with databases, they might not realize this.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.