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.

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

2. At the replicate database, enter this 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';