Creating a maintenance user for replication

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.

1. Connect to the replicate database, and enter the following command to create the maintenance user login:

   CREATE LOGIN maintuser WITH PASSWORD='password', DEFAULT_DATABASE=replicate_db_name;
   

   Here, password is the maintenance user login password, and replicate_db_name is the replicate database name.

2. At the replicate database, enter the following command to create a maintenance user:

   CREATE USER maintuser FOR LOGIN maintuser;
   

3. Grant database owner permission to the maintenance user:

   EXEC sp_addrolemember 'db_owner', 'maintuser';