Creating a replicate database connection

To create a replicate database connection, use sp_addreplicateconn:

sp_addreplicateconn "conn_name"

where conn_name is the connection name in the form ds.db.

If you do not specify a Maintenance User name when you create a replicate connection, the ASE Replicator system user login name is the Maintenance User name for the replicate connection. You have the option to specify a different Maintenance User name when you create a replicate connection. To specify a Maintenance User name for a replicate connection, use 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 name specified.

NoteIf you specify a Maintenance User name that does not exist as an external login, ASE Replicator creates an external login for the Maintenance User name you specify.