Azure SQL database – Reset administrator password

-> I was trying to login to a Azure SQL database using SQL Server management studio and got below error,

TITLE: Connect to Server
Cannot connect to jbreplsub.database.windows.net.
ADDITIONAL INFORMATION:
Login failed for user ‘jvivek2k1’. (Microsoft SQL Server, Error: 18456)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
BUTTONS:
OK

-> I have created this for testing long time ago and don’t remember the password.

-> I decided to reset the administrator password for this Azure SQL Database using below instructions,

  1. Login to Azure portal.
  2. Navigate to the Azure SQL database and click on “Server Name url”,

3. Once in “SQL Server”, click on reset password,

-> I was able to login to Azure SQL database just fine.

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.