To set or change security parameters for the pathway that RepAgent uses to log in to Replication Server, use the sp_config_rep_agent system procedure. Refer to sp_config_rep_agent in the Replication Server Reference Manual for information about this Adaptive Server stored procedure.
To configure the RepAgent pathway, log in to Adaptive Server and execute sp_config_rep_agent at the isql prompt. Here is the syntax:
sp_configure_rep_agent dbname,
{'security mechanism' 'mechanism_name' |
'security_parameter' {'true' | 'false' }}
Table 8-8 describes the security parameters you can set with sp_config_rep_agent. They are stored in the sysattributes table of the database for which RepAgent is enabled. RepAgent parameters are dynamic. They take effect immediately and do not require a reboot of Adaptive Server. You must have sa or dbo permission to execute them.
Settings for the RepAgent pathway differ from typical Replication Server settings in two ways:
For compatibility with other Adaptive Server parameters, parameters for the RepAgent to Replication Server pathway are set to “true” or “false” instead of “required” or “not_required,” respectively. The default value of all parameters is “false.”
The RepAgent parameter that specifies whether to validate the sequence of messages received by Replication Server is msg_out_of_sequence_check and not msg_sequence_check.
To enable, or disable, network-based security at Adaptive Server, or to make other security changes at the Adaptive Server that affect RepAgent, refer to the Adaptive Server Enterprise System Administration Guide.
