Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2007
    Posts
    6

    Question Unanswered: Need help with password complexity

    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?

    Regards,

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    sounds like it's on a different network
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    SQL 2005 introduces Password Complexity rules....OK, not really. SQL Server looks at the OS on the local machine for password policies, and blatantly copies them. In this shop, we only have application logins, so we change the passwords to more complex varieties, and happily go forward, after a few changes to a few configuration files. If you have users that access the database, you should probably set them up with Windows Authenticated logins.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by MCrowley
    SQL 2005 introduces Password Complexity rules....OK, not really. SQL Server looks at the OS on the local machine for password policies, and blatantly copies them. In this shop, we only have application logins, so we change the passwords to more complex varieties, and happily go forward, after a few changes to a few configuration files. If you have users that access the database, you should probably set them up with Windows Authenticated logins.

    Good to know....we do the same thing, but I'm sure it would have been a pitfall on conversion

    What's the complixety rules?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •