Azure Tips and Tricks Part 145 - Easily reset the Administrator password for an Azure SQL database

Intro

Most folks aren’t aware of how powerful the Azure platform really is. As I’ve been presenting topics on Azure, I’ve had many people say, “How did you do that?” So I’ll be documenting my tips and tricks for Azure in these posts.

The Complete List of Azure Tips and Tricks

Available Now!

Easily reset the Administrator password for an Azure SQL database

A common scenario that I have heard folks ask is “How do I reset the Admin password for an Azure SQL database that I’ve forgotten or lost?”

An easy solution to this is

1. Go to the Azure portal

2. Select SQL databases

3. Select the name of the database that you want to change the Admin password.

4. Click on the Server name url for the selected database.

The Reset password option is at the top.

Please note that if you reset the SQL Database server password during a time when there are active connections to databases on the server, you may want to use the KILL statement to terminate user sessions. This will force client connections to refresh their sessions with the database and the host server.

Thanks for reading!

Want more Azure Tips and Tricks?

If you’d like to learn more Azure Tips and Tricks, then follow me on twitter or stay tuned to this blog! I’d also love to hear your tips and tricks for working in Azure, just leave a comment below.