Password Complexity problem

[Nancy]

I need to restore a v2000 database to a v2005 database including all users.

How can I disable password complexity so that I can achieve this ???? I'm sure others have run into this prblem.

Thanks in advance,
Nancy

[rmiao]

Password setting is for sql login instead of db user, you can disable it in sql login properties.

[Nancy]

Can you give an example - I really don't understand what you are saying.
Thanks,
Nancy

[kraaitje]

I think he means that password policy can be forced in the sql server logins instead of the windows policys of your active directory....



Expand security in the object explorer of the sql server management studio. Expand logins.

Edit the user. Disable the "enforce password policy" for the user needed

[Nancy]

Thank you Kraaitje,
Problem is - none of these accounts currently exists. It is a brand new server, brand new install of the database.

1) I created the database with the same name as old
2) Restored the old v2000 to the new v2005
3) In trying to copy over "all" the new accounts using a tool by Idera that scripts "all" the accounts - I get the following 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.

Thanks

[kraaitje]

I think you should consider to change the Active Directory password policy of your domain controller.

[kraaitje]

Change your policy of your active directory

[Nancy]

Thanks trying that now...

[rmiao]

Copy sql logins with ssis copy logins task, you can disable password policy in sql login properties once copied over. Check books online if you don't know sql2k5 basics.

[Nancy]

Thanks all - I got it worked out.