Granting create object Permission to the rs_username User

Grant create object permission to the user ID specified by the Replication Agent rs_username parameter.

The rs_username user,which is used for communication between Replication Agent and Replication Server, must have create object permission before it can be used 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.
    isql -Uusername -Ppassword -SSAMPLE_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.