[CR# 471287] When a new login is created with a password longer than 30 characters, a warning is shown to indicate only the first 30 characters will be used for the password. However, using just the first 30 characters at connection time results in authentication failure.
Workaround: Only set passwords that are 30 characters or less. Reset any long password using sp_password to a password that is only 30 characters.
