The system security officer assigns each user a password when adding the user as a login to Adaptive Server. Users can modify their passwords at any time using sp_password. See “Changing passwords”.
When you create your password:
Do not use information such as your birthday, street address, or any other word or number that has anything to do with your personal life.
Do not use names of pets or loved ones.
Do not use words that appear in the dictionary or words spelled backwards.
The most difficult passwords to guess are those that combine uppercase and lowercase letters and numbers. Never give anyone your password, and never write it down where anyone can see it.
Passwords must:
Be at least 6 characters long.
Consist of any printable letters, numbers, or symbols.
Be enclosed in quotation marks in sp_addlogin if they:
Includes any character other than A – Z, a – z, 0 – 9,_, #, valid single-byte or multibyte alphabetic characters, or accented alphabetic characters
Begin with a number 0 – 9
