Do not assign a null password. When Adaptive Server is installed, the default “sa” account has a null password. The following example shows how to change a null password to a valid one:
sp_password null, "8M4LNCH"
“null” is not enclosed in quotes in the statement.