Replication
Server requires a maintenance user ID that you specify using the
Replication Server create connection command to apply transactions in a replicate database.
The maintenance user ID must be defined at the Microsoft SQL Server
data server and granted authority to apply transactions in the replicate
database. The maintenance user ID must have these permissions in
the Microsoft SQL Server replicate database:
create
table authority to create tables used for Replication
Server processing
update authority on all replicate
tables
execute authority on all replicate
stored procedures