Support for Microsoft Distributed Transaction Coordinator in RDS for SQL Server

To create the option group

1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/.

2. In the navigation pane, choose Option groups.

3. Choose Create group.

4. In the Create option group pane, do the following:

   1. For Name, enter a name for the option group that is unique within your Amazon account, such as msdtc-se-2016. The name can contain only letters, digits, and hyphens.

   2. For Description, enter a brief description of the option group, such as MSDTC option group for SQL Server SE 2016. The description is used for display purposes.

   3. For Engine, choose sqlserver-se.

   4. For Major engine version, choose 13.00.

5. Choose Create.

To create the option group

• Use one of the following commands.

  For Linux, macOS, or Unix:

  aws rds create-option-group \
      --option-group-name msdtc-se-2016 \
      --engine-name sqlserver-se \
      --major-engine-version 13.00 \
      --option-group-description "MSDTC option group for SQL Server SE 2016"

  For Windows:

  aws rds create-option-group ^
      --option-group-name msdtc-se-2016 ^
      --engine-name sqlserver-se ^
      --major-engine-version 13.00 ^
      --option-group-description "MSDTC option group for SQL Server SE 2016"

To add the MSDTC option

1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/.

2. In the navigation pane, choose Option groups.

3. Choose the option group that you just created.

4. Choose Add option.

5. Under Option details, choose MSDTC for Option name.

6. Under Option settings:

   1. For Port, enter the port number for accessing MSDTC. The default is 5000.

   2. For Security groups, choose the VPC security group to associate with the option.

   3. For Authentication type, choose Mutual or None.

   4. For Transaction log size, enter a value from 4–1024. The default is 4.

7. Under Additional configuration, do the following:

   1. For Connections, as needed choose Enable inbound connections and Enable outbound connections.

   2. For Allowed protocols, as needed choose Enable XA and Enable SNA LU.

8. Under Scheduling, choose whether to add the option immediately or at the next maintenance window.

9. Choose Add option.

   To add this option, no reboot is required.

To add the MSDTC option

1. Create a JSON file, for example msdtc-option.json, with the following required parameters.

   {
   "OptionGroupName":"msdtc-se-2016",
   "OptionsToInclude": [
   	{
   	"OptionName":"MSDTC",
   	"Port":5000,
   	"VpcSecurityGroupMemberships":["sg-0abcdef123"],
   	"OptionSettings":[{"Name":"AUTHENTICATION","Value":"MUTUAL"},{"Name":"TRANSACTION_LOG_SIZE","Value":"4"}]
   	}],
   "ApplyImmediately": true
   }

2. Add the MSDTC option to the option group.

   For Linux, macOS, or Unix:

   aws rds add-option-to-option-group \
       --cli-input-json file://msdtc-option.json \
       --apply-immediately

   For Windows:

   aws rds add-option-to-option-group ^
       --cli-input-json file://msdtc-option.json ^
       --apply-immediately

   No reboot is required.

To create the parameter group

1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/.

2. In the navigation pane, choose Parameter groups.

3. Choose Create parameter group.

4. In the Create parameter group pane, do the following:

   1. For Parameter group family, choose sqlserver-se-13.0.

   2. For Group name, enter an identifier for the parameter group, such as msdtc-sqlserver-se-13.

   3. For Description, enter in-doubt xact resolution.

5. Choose Create.

To create the parameter group

• Use one of the following commands.

  For Linux, macOS, or Unix:

  aws rds create-db-parameter-group \
      --db-parameter-group-name msdtc-sqlserver-se-13 \
      --db-parameter-group-family "sqlserver-se-13.0" \
      --description "in-doubt xact resolution"

  For Windows:

  aws rds create-db-parameter-group ^
      --db-parameter-group-name msdtc-sqlserver-se-13 ^
      --db-parameter-group-family "sqlserver-se-13.0" ^
      --description "in-doubt xact resolution"

To modify the parameter group

1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/.

2. In the navigation pane, choose Parameter groups.

3. Choose the parameter group, such as msdtc-sqlserver-se-13.

4. Under Parameters, filter the parameter list for xact.

5. Choose in-doubt xact resolution.

6. Choose Edit parameters.

7. Enter 1 or 2.

8. Choose Save changes.

To modify the parameter group

• Use one of the following commands.

  For Linux, macOS, or Unix:

  aws rds modify-db-parameter-group \
      --db-parameter-group-name msdtc-sqlserver-se-13 \
      --parameters "ParameterName='in-doubt xact resolution',ParameterValue=1,ApplyMethod=immediate"

  For Windows:

  aws rds modify-db-parameter-group ^
      --db-parameter-group-name msdtc-sqlserver-se-13 ^
      --parameters "ParameterName='in-doubt xact resolution',ParameterValue=1,ApplyMethod=immediate"

To create a DB instance with the MSDTC option group and parameter group

• Specify the same DB engine type and major version as you used when creating the option group.

  For Linux, macOS, or Unix:

  aws rds create-db-instance \
      --db-instance-identifier mydbinstance \
      --db-instance-class db.m5.2xlarge \
      --engine sqlserver-se \
      --engine-version 13.00.5426.0.v1 \
      --allocated-storage 100 \
      --manage-master-user-password \
      --master-username admin \
      --storage-type gp2 \
      --license-model li \
      --domain-iam-role-name my-directory-iam-role \
      --domain my-domain-id \
      --option-group-name msdtc-se-2016 \
      --db-parameter-group-name msdtc-sqlserver-se-13

  For Windows:

  aws rds create-db-instance ^
      --db-instance-identifier mydbinstance ^
      --db-instance-class db.m5.2xlarge ^
      --engine sqlserver-se ^
      --engine-version 13.00.5426.0.v1 ^
      --allocated-storage 100 ^
      --manage-master-user-password ^
      --master-username admin ^
      --storage-type gp2 ^
      --license-model li ^
      --domain-iam-role-name my-directory-iam-role ^
      --domain my-domain-id ^
      --option-group-name msdtc-se-2016 ^
      --db-parameter-group-name msdtc-sqlserver-se-13

To modify a DB instance and associate the MSDTC option group and parameter group

• Use one of the following commands.

  For Linux, macOS, or Unix:

  aws rds modify-db-instance \
      --db-instance-identifier mydbinstance \
      --option-group-name msdtc-se-2016 \
      --db-parameter-group-name msdtc-sqlserver-se-13 \
      --apply-immediately

  For Windows:

  aws rds modify-db-instance ^
      --db-instance-identifier mydbinstance ^
      --option-group-name msdtc-se-2016 ^
      --db-parameter-group-name msdtc-sqlserver-se-13 ^
      --apply-immediately

To remove the MSDTC option from its option group

1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/.

2. In the navigation pane, choose Option groups.

3. Choose the option group with the MSDTC option (msdtc-se-2016 in the previous examples).

4. Choose Delete option.

5. Under Deletion options, choose MSDTC for Options to delete.

6. Under Apply immediately, choose Yes to delete the option immediately, or No to delete it at the next maintenance window.

7. Choose Delete.

To remove the MSDTC option from its option group

• Use one of the following commands.

  For Linux, macOS, or Unix:

  aws rds remove-option-from-option-group \
      --option-group-name msdtc-se-2016 \
      --options MSDTC \
      --apply-immediately

  For Windows:

  aws rds remove-option-from-option-group ^
      --option-group-name msdtc-se-2016 ^
      --options MSDTC ^
      --apply-immediately