SQL Azure - Resetting SQL Azure Database Administrator Credentials

Article

Introduction:

In this article we are going to see how to do a reset of the SQL Azure database administrator credentials (Password) basically using the SQL Azure management Portal

Overview:

Traditionally changing the SQL Server database password to enforce some password security is very important task for ensuring data security. Similarly in a SQL Azure database we have the option to change the password credentials of the Administrator. Let us jump start to see how to change the credentials of the administrator password step by step.

Steps:

http://www.microsoft.com/windowsazure/

Login to the portal using your Microsoft Windows Live credentials with Azure credentials to the management portal and you will see the screen as shown in the screen below:

Now we can see the Database Menu at the bottom left; click on that to go to the Database Subscription window as shown in the screen below:

Clicking on the subscription name will provide the complete details of the server created and the new databases created as shown in the screen below:

Now select a particular server by clicking on the server name at the left menu as shown in the following screen and then we can see the information specific to the server with the Administrator details as well.

Now select the Reset Administrator Password option at the top Menu as shown in the screen below. Using this option, we can reset the Administrator credentials as needed and we can do it any number of times as and when required as shown in the screen below:

Enter the new credentials as per the Password Policy else we will get a Validation error as shown in the screen below:

So enter the credentials as per the policy and retype the same password and click on the OK button as shown in the screen below:

When you are done set up with the new Credentials for the Administration; we can check the new credentials by logging out and then logging in with the new password