Configuring Replication Server for Replication from the Primary Database

Configure Replication Server for replication from the primary database by granting create object permission to the rs_username user.

The rs_username user, which is used for communication between Replication Agent and Replication Server, must have create object permission before you can use it to create a replication definition. You must grant this permission manually from Replication Server.

  1. Log in to Replication Server:
    isql -Usa -Psa_pass -SSAMPLE_RS
    If you have not set up the sample Replication Server instance, enter your Replication Server instance name in place of SAMPLE_RS.
  2. Enter:
    grant create object to SAMPLE_RS_ra
go

    where SAMPLE_RS_ra is the value for the rs_username parameter you entered in the resource file.

Parent topic: Configuring Replication Server