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.
| Function | High-availibility series | Basic series | |
|---|---|---|---|
| 2016 Standard, Enterprise 2012 Standard, Enterprise | 2008 R2 Enterprise | 2016 Web 2012 Web 2012 Enterprise | |
| Maximum number of databases (Note) | 50 | 50 | 100 |
| Maximum number of database accounts | Unlimited | 500 | Unlimited |
| Create user, LOGIN, or database (Note) | Supported | Supported | Supported |
| Database-level DDL trigger | Supported | Not supported | Supported |
| Database permission authorization | Supported | Not supported | Supported |
| KILL permission | Supported | Supported | Supported |
| LinkServer | Supported | Not supported | Not supported |
| Distributed transaction | Supported | Not supported | Not supported |
| SQL Profiler | Supported | Supported | Supported |
| Tuning Advisor | Supported | Not supported | Supported |
| Change Data Capture (CDC) | Supported | Not supported | Supported |
| Chage Tracking | Supported | Supported | Supported |
| Windows domain account login | Not supported | Not supported | Not supported |
| 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.