Changing Configuration Values in a Replication Path

Use the config parameter with sp_replication_path to set parameter values in alternate replication paths.

You can change only the password and user ID for alternate replication paths.

To change the value of a parameter for an alternate path, enter:

sp_replication_path dbname, 'config', "path_name",
 "config_parameter_name", "config_value"

where config_parameter_name is rs_username or rs_password.

For example, to change the:

User name that pdb_1 uses to connect to RS1 to "RS1_user", enter at PDS:

sp_replication_path pdb, 'config', "pdb_1", "rs_username", “RS1_user”

Password that pdb_1 uses to connect to RS1 to "january", enter at PDS:

sp_replication_path pdb, 'config', "pdb_1", "rs password", “january”

Use sp_config_rep_agent to configure parameters for the default replication path. See Replication Server Reference Manual > Adaptive Server Commands and System Procedures > sp_config_rep_agent.