Execute sp_config_rep_agent to enable the RepAgent for the database and set default values for RepAgent configuration parameters. You can reset the default values at a later time.
Log in to Adaptive Server. At the isql prompt, enter:
use dbname
go
sp_config_rep_agent dbname, enable, 'repserver_name', 'repserver_username', 'repserver_password'
dbname is the name of the database for which you are enabling RepAgent, repserver_name is the Replication Server to which RepAgent connects, and repserver_username and repserver_password are the name and password RepAgent uses to log in to Replication Server.
Make sure that repserver_username is
a valid Replication Server user and that it has Replication Server connect
source permission. Try out the user name and password
at the Replication Server before you use sp_config_rep_agent.
Refer to “Configuring RepAgent” for information about setting RepAgent parameters with sp_config_rep_agent.
