Password not accepted for newly created user under SQL Server 2008 R2 Enterprise

Question

I understand the limitation of a strong password choice under SQL Server 2008 R2 Enterprise. I have a software that must use a specific password, which works on the Standard version of SQL Server; however, Enterprise is refusing to add the user because the password is weak and not fulfilling the requirements.

Is there any workaround for this? The server is for testing, so it is not a production server.

Answer 1

You need to change the Local Security Policy, under Account Policies, Password Policy: "Password must meet complexity requierements" to Disabled