Limits

Last Updated: May 04, 2018

RDS for SQL Server instances are all granted Microsoft SQL Server licenses and do not support users’ own licenses. Furthermore, to guarantee instance stability and security, SQL Server has certain limits.

FunctionHigh-availibility seriesBasic series
2016 Standard, Enterprise
2012 Standard, Enterprise
2008 R2 Enterprise2016 Web
2012 Web
2012 Enterprise
Maximum number of databases (Note)5050100
Maximum number of database accountsUnlimited500Unlimited
Create user, LOGIN, or database (Note)SupportedSupportedSupported
Database-level DDL triggerSupportedNot supportedSupported
Database permission authorizationSupportedNot supportedSupported
KILL permissionSupportedSupportedSupported
LinkServerSupportedNot supportedNot supported
Distributed transactionSupportedNot supportedNot supported
SQL ProfilerSupportedSupportedSupported
Tuning AdvisorSupportedNot supportedSupported
Change Data Capture (CDC)SupportedNot supportedSupported
Chage TrackingSupportedSupportedSupported
Windows domain account loginNot supportedNot supportedNot supported
Email
SQL Server Integration Services (SSIS)
SQL Server Analysis Services (SSAS)
SQL Server Reporting Services (SSRS)
R Services
Common Language Runtime (CLR)
Asynchronous communication
Replication
Policy management

Note:

  • For SQL Server 2012/2016, you can submit a ticket to request a higher maximum number of databases.

  • For SQL Server 2008 R2 Enterprise, you can manage accounts, LOGINs, and databases through the console or OpenAPI.

  • For SQL Server 2012 and later versions, create an initial account through the console or OpenAPI and then use the initial account and SQL statements to manage accounts, LOGINs, and databases.

Thank you! We've received your feedback.