Password Complexity problem

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

You can do this. Password complexity is a feature of the underlying OS (Windows 2003 and greater). the policy is a local policy which can be overwritten by a domain policy. Open the MMC add the Group Policy Editor (for local computer) and navigate to the security settings. if you are domain controlled, you will see the setting evtl. greyed out. You will have to ask your administrator then to temporary disable it for this server.

Jens K. Suessmeyer

http://www.sqlserver2005.de