Configure the Target Database

  1. From within SQL Server Management Studio, select SQL Server Authentication and connect to the SQL Server RDS instance using the following parameters:

    Parameter Value
    Server Type Database Engine
    Server Name < TargetSQLServerEndpoint >
    Login awssct
    Password Password1
  2. Open a New Query window.

  3. Run the following script to create a target database dms_recovery on RDS SQL Server.

use master

CREATE DATABASE dms_recovery

The target database (dms_recovery) has now been created. Please return to the AWS Management Console.