Creating a maintenance user for replication

This section explains how to create a maintenance user in the replicate Microsoft SQL Server database.

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. Using the Microsoft SQL Server Management Studio or the sqlcmd utility, connect to the replicate database, and enter the following command to create 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';