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

cnilsson

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?

petey

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

cnilsson

Thank you petey!

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

Chris

petey

Thanks for pointing that out. I've raised a bug report for this, which should be fixed in the next release.