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.
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: