Add databases to Replication Server

You must create connections in the Replication Server for the primary and standby databases.

You must have “sa” permission in the Replication Server to perform this procedure.

To create database connections in Replication Server

Log in to the Replication Server with a user login that has “sa” permission.
Create the logical connection for the primary and standby databases:
```
create logical connection to
   logical_ds.logical_db
```
where:
- logical_ds is the name of the logical data server in a warm standby application.
- logical_db is the name of the logical database in a warm standby application.
The logical data server name (logical_ds) and logical database name (logical_db) need not be the same as the actual names of the primary data server and primary database. See the Replication Server Administration Guide for more information about logical connections.
Create a database connection for the primary database:
```
create connection to pds.pdb
   set error class rs_sqlserver_error_class
   set function string class
      rs_sqlserver_function_class
   set username "mra_maint" 
   set password  "mra_maint_pwd"  
   with log transfer on
   as active for logical_ds.logical_db
```
where:
- pds is the name of the primary data server.
- pdb is the name of the primary database.
- mra_maint is the Maintenance User login for the primary database.
- mra_maint_pwd is the password for the Maintenance User.
- logical_ds is the logical data server identified in the logical connection.
- logical_db is the logical database identified in the logical connection.
Create a database connection for the standby database:
```
create connection to sds.sdb
   set error class rs_sqlserver_error_class
   set function string class
      rs_sqlserver_function_class
   set username "mra_maint" 
   set password  "mra_maint_pwd"
   with log transfer on
   as standby for logical_ds.logical_db
```
where:
- sds is the name of the standby data server.
- sdb is the name of the standby database.
- mra_maint is the Maintenance User login for the standby database.
- mra_maint_pwd is the password for the Maintenance User.
- logical_ds is the logical data server identified in the logical connection.
- logical_db is the logical database identified in the logical connection.