.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> Azure >> Post New Resource Bookmark and Share   

 Subscribe to Articles

SQL Azure - Resetting SQL Azure Database Administrator Credentials

Posted By:Karthikeyan Anbarasan       Posted Date: June 28, 2011    Points: 200    Category: Azure    URL: http://www.dotnetspark.com  

SQL Azure - Resetting SQL Azure Database Administrator Credentials
 

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/

image

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

screenshot_02

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

image

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

image

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

image

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

image

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

image

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

image

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


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend