What are the challenges you face when working across database platforms? Take the survey
Options

"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?

Comments

  • Options
    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
  • Options
    Thank you petey!

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

    Chris
  • Options
    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
Sign In or Register to comment.