If you do not specify a Maintenance User name when you create a replicate connection, the ASE Replicator system user is the Maintenance User for the replicate connection.
To create a replicate database connection with
the default Maintenance User
Use sp_addreplicateconn with the following syntax:
sp_addreplicateconn "conn_name"
where conn_name is the connection name in the form ds.db.
You have the option to specify a different Maintenance User name when you create a replicate connection.
To specify a different Maintenance User name for
a replicate connection
Use sp_addreplicateconn with the following syntax:
sp_addreplicateconn "conn_name", maint_user, maint_pw
where conn_name is the connection name in the form ds.db, maint_user is the Maintenance User name for the replicate database, and maint_pw is the password for the Maintenance User.
If you specify a Maintenance User name that does not
already exist as an external login on the primary Adaptive Server, ASE Replicator creates
an external login for the Maintenance User name you specify.
