Options for the Microsoft SQL Server database engine - Amazon Relational Database Service

Options for the Microsoft SQL Server database engine

In this section, you can find descriptions for options that are available for Amazon RDS instances running the Microsoft SQL Server DB engine. To enable these options, you add them to an option group, and then associate the option group with your DB instance. For more information, see Working with option groups.

If you're looking for optional features that aren't added through RDS option groups (such as SSL, Microsoft Windows Authentication, and Amazon S3 integration), see Additional features for Microsoft SQL Server on Amazon RDS.

Amazon RDS supports the following options for Microsoft SQL Server DB instances.

Option Option ID Engine editions

Native backup and restore

SQLSERVER_BACKUP_RESTORE

SQL Server Enterprise Edition

SQL Server Standard Edition

SQL Server Web Edition

SQL Server Express Edition

Transparent Data Encryption

TRANSPARENT_DATA_ENCRYPTION (RDS console)

TDE (AWS CLI and RDS API)

SQL Server 2012–2019 Enterprise Edition

SQL Server 2019 Standard Edition

SQL Server Audit

SQLSERVER_AUDIT

In RDS, starting with SQL Server 2012, all editions of SQL Server support server level audits, and Enterprise edition also supports database level audits.

Starting with SQL Server SQL Server 2016 (13.x) SP1, all editions support both server and database level audits.

For more information, see SQL Server Audit (database engine) in the SQL Server documentation.

SQL Server Analysis Services

SSAS

SQL Server Enterprise Edition

SQL Server Standard Edition

SQL Server Integration Services

SSIS

SQL Server Enterprise Edition

SQL Server Standard Edition

SQL Server Reporting Services

SSRS

SQL Server Enterprise Edition

SQL Server Standard Edition

Microsoft Distributed Transaction Coordinator

MSDTC

In RDS, starting with SQL Server 2012, all editions of SQL Server support distributed transactions.