Post reply

SQL 2005 on Windows 2000

  • December 13, 2005 at 9:24 am

    #166811

    Has anyone run SQL Server 2005 on Windows 2000.

    I try to create a login with test as password, and I get the following message

    2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]Password validation failed. The password does not meet Windows policy requirements because it is not complex enough. - 1

    But, there is a policy enabled on my Windows 2000 box.

    Thanks

    Haritha

     

  • December 14, 2005 at 7:51 am

    #609469

    The password of the login you created does not meet your windows security policy (e.g. the length of password, etc). If you want to ignore the policy for the login, you can use WITH CHECK_POLICY=OFF option in your CREATE LOGIN statement.

     

  • December 15, 2005 at 3:37 am

    #609676

    Use a complex password.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply