Showing posts with label Reset Password for Azure SQL Database. Show all posts
Showing posts with label Reset Password for Azure SQL Database. Show all posts

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.