November 4, 2008 at 7:31 am
I need to restore a v2000 database to a v2005 database including all users. It's a brand new server and database. When I try to copy all of the new accounts, I get this error:
Msg 15118, Level 16, State 1, Line 1
Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.
What do I do with the password complexity? Any ideas?
November 4, 2008 at 7:48 am
SQL 2005 has an additional security check to ensure that passwords for logins meet the strong password requirements (i.e. at least 8 characters long, combines letters,numbers and symbols etc
Either you need to script out your logins and change their passwords to strong passwords (recommended) or alter your login create script as: CREATE LOGIN , CHECK_POLICY=OFF
By default the CHECK_POLICY is set to on in the CREATE LOGIN statement...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply