Set up the Maintenance User in the primary database

Setting up the Maintenance User involves:

Adding the Maintenance User login to the primary data server
Granting the Replication role to the Maintenance User login
Adding the Maintenance User to the primary database

Use the following procedure to set up the Maintenance User login in the primary database.

You must have a System Administrator user role in the primary Adaptive Server to perform this procedure.

To set up the Maintenance User in the primary database

Log in to the primary Adaptive Server with a System Administrator user role.
Add the Maintenance User login name to the primary data server:
```
use master
sp_addlogin mra_maint, mra_maint_pwd, pdb
```
where:
- mra_maint is the Maintenance User login name.
- mra_maint_pwd is the password for the Maintenance User.
- pdb is the name of the primary database.
The Maintenance User login can be the same as the Mirror Replication Agent user login in the primary database. This can simplify managing user permissions and setting up the Mirror Activator system.
Grant the Replication role to the Maintenance User:
```
grant role replication_role to mra_maint
```
where mra_maint is the Maintenance User login name.
Add the Maintenance User to the primary database:
```
use pdb
sp_adduser mra_maint
```
where:
- pdb is the name of the primary database.
- mra_maint is the name of the Maintenance User in the primary database.

After you set up the Maintenance User in the primary data server, verify that the Maintenance User can log in to the primary data server and access the primary database.