Resetting a Lost or Forgotten sa User Password

Use the reset_password=sa parameter to reset the password for the sa user if you lose or forget the password. You cannot use the parameter to reset passwords of any other account.

1. Add the reset_password=sa parameter to the Replication Server configuration file.
   Note: You cannot use isql to run reset_password=sa.
2. Restart Replication Server.
   During start-up, Replication Server generates a random password for one-time use for the sa user. The reset_password=sa parameter is then removed from the configuration file to prevent password from being generated during subsequent restarts.
3. Log in as the sa user using the generated one-time password.
   The password expires immediately, and Replication Server locks the sa user account to prevent another user from attempting to log in using the same password. Replication Server notifies the sa user that the password has expired.
4. Enter a new password that meets all the requirements.