Monday, 31 July 2017

Reset Password for Azure SQL Database

Reset Password for Azure SQL Database



It is very common for all of us to forget the passwords/credentials and thankfully there are ways to reset them. However hard we try to remember the passwords we tend to forget them for some reasons over the time. Last week the similar issue happened with me as well. While I was working on an Azure SQL Database problem (which is also referred as Platform as a service PASS or Database as a service DAAS), I realized that my password was not working as the one which I was entering was wrong. Upon retrying once more I checked and observed that I was getting login failed error which points to wrong credentials supplication -


“TITLE: Connect to Server
------------------------------


Cannot connect to sqldbserver11.database.windows.net,1433.


------------------------------
ADDITIONAL INFORMATION:


Login failed for user 'rahul'. (Microsoft SQL Server, Error: 18456)




------------------------------





Reset Passwords for Azure SQL Database through Microsoft Azure portal











The error was login failed and was shown on the connection screen itself. I have already written a detailed article which you can check here-> Create an Azure SQL Database on how to create a SQL Azure database using Azure Portal and connect to it using SSMS (SQL Server Management Studio). Since admin password is required to get connected to SQL database (as in my case I did not create any other login other than admin account), I thought of resetting it.


To reset password for Azure SQL Database please perform the following steps-



  1. Login to portal.azure.com with your credentials
  2. Click on the SQL Databases-


Reset Passwords for Azure SQL Database using the Azure Portal









3) When you will click on SQL Databases you will be shown all the available SQL Databases that are installed on the azure portal. You will need to identify for which Azure SQL database you want to reset password. Please make sure that you select the database for which you have forgotten the password and want to do a password reset. Example here I have selected Test SQL database-and then I clicked on Overview.


4) You will now need to click on the Server name from the overview window. In my example, I will click on the fully qualified server name which is - sqldbserver11.database.windows.net.


5) You will be presented with another window where you can see the “Reset Password” link.


6) Post clicking to “Reset Password” link you will get a window to reset password for admin account-


Reset Passwords for Azure SQL Database















7) Supply the new password and confirm the new password to reset the admin password for Azure SQL Database. Please make sure you enter a password that meets all the security standards Once you have verified both new password and confirm password fields please click on the save option to save the newly set password for the admin account. After resetting the password, you should come back to your SSMS screen and try to connect again using the new password and you should be able to get in.


After resetting the password for Azure SQL database (test Azure SQL Database in my example) by following the above steps I tried to reconnect the database via SSMS (SQL Server Management Studio) and I was able to get connected to it.

6 comments:

  1. This is of great help to me.

    Thank you

    ReplyDelete
  2. All you need is a small USB Flash Drive. This way is more easy and secure that it has no limitation. It will list all user accounts of your computer, you just need to click whichever user account and click Reset Password button. Software for password recovery

    ReplyDelete
  3. Great Post,really it was very helpful for us.
    Thanks a lot for sharing!
    I found this blog to be very useful!!
    Microsoft Azure training in Bangalore

    ReplyDelete
  4. Thank you for your valuable content , Easy to understand and follow. As said, the migration to cloud is very essential for the protection of the database.

    Cloud Migration services
    Aws Cloud Migration services
    Azure Cloud Migration services
    Vmware Cloud Migration services
    Database Migration services

    ReplyDelete
  5. You should continue writing such blogs, it was informative. Also, within your appreciation, I just want to add that you can buy World Zip Code Database from World Cities Database at very reasonable prices.

    ReplyDelete