Updated on 2023-07-06 GMT+08:00

Microsoft SQL Server Constraints

RDS for SQL Server only supports DB instances under the License Included model and does not support "bring your own license" (BYOL). After a DB instance is created, it contains the Microsoft SQL Server software license.

Table 1 shows the constraints designed to ensure the stability and security of RDS for SQL Server.

Microsoft SQL Server DB instances are classified into three types: single, primary/standby, and cluster. Different types support different functions.

Table 1 Function constraints

Function Item

Single

Primary/Standby

Maximum number of databases

100 (can be increased)

100 (can be increased)

Number of database accounts

Unlimited

Unlimited

Creation of user, LOGIN, or database

Supported

Supported

Database-level DDL trigger

Supported

Supported

Database permission authorization

Supported

Supported

KILL permission

Supported

Supported

SQL Profiler

Supported

Supported

Tuning Adviser

Supported

Supported

Change Data Capture (CDC)

Supported

Supported

Change tracking

Supported

Supported

Windows domain account login

Supported

Supported

SQL Server Integration Services (SSIS)

Not supported

Not supported

SQL Server Analysis Services (SSAS)

Not supported

Not supported

R Services

Not supported

Not supported

Asynchronous communication

Not supported

Not supported

Replication subscription

Not supported

Not supported

Policy management

Not supported

Not supported