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,1433.


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

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.


  1. This is of great help to me.

    Thank you

    1. Great Article Cloud Computing Projects

      Networking Projects

      Final Year Projects for CSE

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

  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

  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

  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

  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.

  6. You need to participate in a challenge for probably the best webpage on the web. I will enthusiastically suggest this site! news updates