Contents Index Running the Message Agent Running multiple Message Agents

SQL Remote User's Guide
  Administering SQL Remote for Adaptive Server Enterprise
    Running the Message Agent

The Message Agent and replication security


In the tutorials earlier in this book, the Message Agent was run using a user ID with system administrator permissions. The operations in the messages are carried out from the user ID specified in the Message Agent connection string; by using a system administrator user ID, you can be sure that the user has permissions to make all the changes.

In practice, you will not use such a user ID, but the Message Agent needs to run using a user ID with replication role. You can grant replication role with the following statement:

sp_role 'grant', replication_role, user_name

The user for the Message Agent must have insert, update and delete permissions on all replicated tables, in order to apply the changes. Also, the replication error procedure must be created under the Message Agent user ID.

When you setup your Adaptive Server Enterprise database, the scripts ssremote.sql and squeue.sql must be run under the same user name you use for the Message Agent.

For setup instructions, see Setting Up SQL Remote.

To hide the user password for the Message Agent user ID, you can store the ssremote command-line options in a file, and use ssremote with the @filename parameter. You can use file system security to prevent unauthorized access to the file.


Contents Index Running the Message Agent Running multiple Message Agents