Creating a Maintenance User for Replication in Microsoft SQL Server
The maintenance user is a valid Microsoft SQL Server user
that the Replication Server uses to apply commands to the replicate
Microsoft SQL Server database. Replication Server requires one maintenance
user to be defined for each connection.
Connect to the replicate database, and
enter this command to create the maintenance user login:
CREATE LOGIN maintuser WITH PASSWORD='password',
DEFAULT_DATABASE=replicate_db_name;
where password is the maintenance user
login password, and replicate_db_name is
the replicate database name.
At the replicate database, enter this
command to create a maintenance user:
CREATE USER maintuser FOR LOGIN maintuser;
Grant database owner permission to the maintenance
user: