Amazon RDS for SQL Server now supports Distributed Transactions
Starting today, Amazon RDS for SQL Server supports distributed transactions using Microsoft Distributed Transaction Coordinator (MSDTC). You can execute distributed transaction on DB instances that are domain joined using the AWS Directory Service for Microsoft Active Directory.
Starting today, Amazon RDS for SQL Server supports distributed transactions using Microsoft Distributed Transaction Coordinator (MSDTC). You can execute distributed transaction on DB instances that are domain joined using the AWS Directory Service for Microsoft Active Directory.
With MSDTC you can either execute the transaction using SQL Server as the Transaction manager using linked servers, or you can promote MSDTC running on the same host as the Client application to the role of Transaction manager.
Learn more about how to configure MSDTC in RDS from this Blog post, and see the Amazon Relational Database Services User Guide for more information.
Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability.