In this Azure SQL tutorial, I will explain the error ‘Password validation failed. The password does not meet policy requirements because it is not complex enough.‘
Recently, I was trying to change my user password in the Azure SQL database. I was using SQL Server management studio to connect to my Azure SQL database.
I was trying to change the password with the ALTER USER statement. The query is written below:
ALTER USER TestUser WITH PASSWORD= 'password' OLD_PASSWORD= 'User@123'
The old password is ‘User@123′ and I was trying to change it to the new password which was ‘password’.
This query resulted in an error as shown below in the image:
Reason: Password validation failed sql server
I searched about the error on the web and found why I was getting this error.
When you want to set a new password for any user, you have to set the password according to the password policy implemented by Microsoft Azure.
The following are the rules of the password policy that you have to follow while changing the user password in the Azure SQL database:
- The length of the password should be equal to or greater than 8 characters.
- The password should not contain the username whose password you are going to set.
- The password should follow at least one of the three rules out of four:
- The password should contain Latin uppercase letters(A to Z)
- It should container Latin lowercase letters(a to z)
- Numeric values(0 to 9)
- Non alpanumeric charachters like the symbols on your keyboard.
Solution: Azure Password validation failed
Following the Azure password policy, I selected a new password and changed the user password to this user password:
ALTER USER TestUser WITH PASSWORD= 'Password@123' OLD_PASSWORD= 'User@123'
You can also use a password generator while creating a new password for the Azure SQL database.
In this way, I was able to resolve the error Azure sql password validation failed.
- Password validation failed. The password does not meet policy requirements because it is not complex enough.
- Migrate SQL Server to Azure SQL database
- Bulk loading data to Azure SQL
- Configuring email notifications in Azure SQL database
- How to create SQL authentication user in Azure SQL database
- Reset Password Azure SQL database
- Cannot open backup device operating system error 50 azure
- Backup and restore SQL Server to Azure Blob storage
After working for more than 15 years in the Software field, especially in Microsoft technologies, I have decided to share my expert knowledge of SQL Server. Check out all the SQL Server and related database tutorials I have shared here. Most of the readers are from countries like the United States of America, the United Kingdom, New Zealand, Australia, Canada, etc. I am also a Microsoft MVP. Check out more here.