"Warning 462: short passwords may not be secure" w/ long pwd

cnilssoncnilsson Posts: 9
edited September 17, 2009 1:11AM in SQL Backup Previous Versions
We are getting this warning "Warning 462: short passwords may not be secure" when our password is longer than 4 characters.

As a warning it shows up in our alerts even though it is not an error.

Any ideas?
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    Warning 462 is raised when the password is less than 8 characters in length.

    If you want to remove this warning, I would suggest amending the script so that it specifically ignores this warning e.g.
    IF ( (@exitcode > 0) AND (@exitcode <> 462) ) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d  SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • cnilssoncnilsson Posts: 9
    Thank you petey!

    By the way, the Help file and the warning itself shows that error for passwords shorter than 4 characters.

    Chris
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    Thanks for pointing that out. I've raised a bug report for this, which should be fixed in the next release.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.