User's Manual

2. Grant PUBLISH permissions to a user ID to identify the source of
outgoing messages.
3. Grant REMOTE permissions to all user IDs that are to receive messages.
4. Create a publication describing the data to be replicated.
5. Create subscriptions describing who is to receive the publication.
You should have system administrator authority to carry out these tasks.
Create the message links and addresses
In this tutorial, messages are exchanged using the shared file link. You must
create a FILE message type supplying the address of the consolidated
database publisher.
❖ To create the message type
1. Execute the sp_remote_type stored procedure, using HQ as the address
of the consolidated database publisher:
sp_remote_type file, hq
go
The address (hq) for a file link is a directory in which files containing the
message are placed. It is taken relative to the SQLRemote environment
variable or registry entry. As you have not set this value, the address is
taken relative to the directory from which the Message Agent is run. You
should run the Message Agent from your tutorial directory for the
addresses to be interpreted properly.
☞ For information about setting the SQLRemote value, see “Setting
message type control parameters” on page 214.
With the message type defined, you can now make the necessary users.
Create the necessary users and permissions
A set of users and permissions are required for SQL Remote installations. In
this tutorial, the following are required:
♦ A remote user or subscriber, with name field_user.
♦ A publisher user name, called hq_user.
This section describes the steps you need to take to create each user and
assign them the necessary permissions.
60