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 much important task to ensure data security. Similarly in SQL Azure database we have option to change the password credentials of the Administrator.

Let us jump start to see on how to change the credentials of the administrator password step by step

Steps:

Log in to the Azure portal using the below link. You can see the screen look similar to below

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 will 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 screen below and we can see the information specific to the server with the administrator details as well

Now Select Reset Admin Password option at the top Menu as shown in the screen below. Using this option we can reset the admin credentials as per our wish and we can do it n 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 OK button as shown in the screen below

Once done we are 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

Conclusion:

So in this article we have seen how to reset the administrator credentials using the Azure Management Portal