How to Reset the Admin Password for an Azure SQL Database

Follow these six steps to reset a Microsoft Azure SQL (domain-specific language) database administrator password:

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 for.

4. Click on the Server name URL link for the selected database.[image_with_animation image_url=”24154″ animation=”None” hover_animation=”none” alignment=”center” img_link_target=”_blank” border_radius=”none” box_shadow=”none” image_loading=”lazy-load” max_width=”100%” max_width_mobile=”default”]5. The Reset password option is at the top.[image_with_animation image_url=”24156″ animation=”None” hover_animation=”none” alignment=”center” img_link_target=”_blank” border_radius=”none” box_shadow=”none” image_loading=”lazy-load” max_width=”100%” max_width_mobile=”default”]6. Once the reset has completed successfully you’ll see a notification in the top right hand corner of your Azure portal as shown below.[image_with_animation image_url=”24159″ animation=”None” hover_animation=”none” alignment=”center” img_link_target=”_blank” border_radius=”none” box_shadow=”none” image_loading=”lazy-load” max_width=”50%” max_width_mobile=”default”]

Important notes:

• The admin login name cannot be changed after it has been created.
• 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.

Brandon | PEI