I am trying to create a login for an external user to access one of my Azure databases.
I am unable to get past the error of:
Password validation failed. The password does not meet policy requirements because it is not complex enough.
But, I have tried all different combinations - some are crazy complex.
This is an example of my script that fails...
CREATE LOGIN tableau WITH password='__&&**!!!!123**&&__lklkjljkjkl*&*&%^&^$%lkjlkjklhJHGJHGJ' GO
I have the "master" database selected and I am following instructions in this article:
How to create custom user login for Azure SQL Database
Can anyone suggest what I might be doing wrong please?
Thanks
Password Complexity The password is at least eight characters long. The password contains characters from three of the following four categories: Latin uppercase letters (A through Z) Latin lowercase letters (a through z)
Description. The remote instance of MS SQL / SQL Server has the default 'sa' account enabled without any password.
Another option is to remove the strong password requirement during SQL server installation. Navigate to Start > Administrative Tools > Local Security Policy Expand Account Policies > Password Policy. Right-click on Password must meet complexity requirements. Select Properties > Disabled and click OK.
In SQL Server Management Studio Object Explorer, navigate to >> Security >> Logins >> . Right-click, select Properties. Select the check box Enforce Password Policy. Click OK.
From this article https://msdn.microsoft.com/en-us/library/azure/jj943764.aspx you have to meet these requirements:
8 characters minimum and 16 characters maximum
Requires 3 out of 4 of the following:
Lowercase characters
Uppercase characters
Numbers (0-9)
Symbols (see password restrictions above)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With