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.
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |