Manage Replication Server Login Names and Passwords

The replication system administrator, or any other user who has sa permission, can manage login names, and implement and administer password security.

• Concealing Password Input
  Use the isql --conceal option, with the ":?" wildcard characters, to conceal the passwords you set when you create or alter users.
• Create a Replication Server Login Name
  Use the create user command to add new user login names to Replication Server.
• Change a Replication Server Password
  The replication system administrator can change the password of any user with the alter user command. A user can change his or her own password.
• Password Configuration Options for All Users
  There are several configure replication server options you can use to implement and administer Replication Server password security for all users. Replication Server uses password encryption instead of clear text when storing all passwords for new Replication Server installations.
• Drop a Replication Server Login Name
  Use the drop user command to remove an existing login name from the Replication Server.
• 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.