Tuesday, October 23, 2012

The specified sa password does not meet strong password requirements

Problem:
When installing SQL Server 2008 R2 when you go to specify the sa password you get an error message stating that the password doesn't meet complexity requirements. 

Solution
From this thread  msdn thread, the post that helped me was the following:

Several simple solution steps:

If computer is on a domain
1. Go to Administrative Tools / Domain Security Policy :: Security Settings | Account Policies | Password Policy
2. Ensure "Minimum password length" and "Password must meet complexity requirements" set to "Not Defined" state.

Not on domain
3. Go to Administrative Tools / Local Security Policy :: Security Settings | Account Policies | Password Policy
4. Turn "Minimum password length" to zero and "Password must meet complexity requirements" to "Disable"

3 comments:

  1. Eranga PriyakaraMay 11, 2015 at 9:23 PM

    Thank you.. you saved my time even after 1 1/2 years of this post!

    ReplyDelete

There was an error in this gadget