tencent cloud


Constraints and Limits

Last updated: 2022-05-27 15:38:31

TencentDB for SQL Server only offers instances with attached licenses. When an instance is created, it is licensed with the appropriate Microsoft SQL Server edition. You cannot bring your own license.

In order to ensure the stability and security of instances, TencentDB for SQL Server has certain restrictions on usage as detailed below.

TencentDB for SQL Server is available in three editions: Basic, Dual-Server High Availability, and Cluster, each with its own set of features. For more information, see Features and Differences.


If you have other questions about usage restrictions, submit a ticket for assistance.

FeatureCluster EditionDual-Server High Availability EditionBasic Edition
Database version2017 Enterprise
2019 Enterprise
2008 R2 Enterprise
2012 Standard/Enterprise
2014 Standard/Enterprise
2016 Standard/Enterprise
2017 Standard/Enterprise
2019 Standard/Enterprise
2008 R2 Enterprise
2012 Enterprise
2014 Enterprise
2016 Enterprise
2017 Enterprise
2019 Enterprise
Maximum number of databases2017: 70
2019: 70
2008 R2, 2012, 2016, 2017: 70
2019: 70
2014: 70
Maximum number of database accountsUnlimitedUnlimitedUnlimited
Database creationSupportedSupportedSupported
User/Login account creation and deletionSupportedSupportedSupported
SA account creationNot supportedNot supportedSupported
Database authorizationSupportedSupportedSupported
Database-level DDL triggerSupportedSupportedSupported
Thread killing permissionSupportedSupportedSupported
SQL profilerSupportedSupportedSupported
Pub/SubSupportedSupportedNot supported
Optimization advisorNot supportedNot supportedSupported
Linked server
  • Supported only in Tencent Cloud private network
  • Not supported between other clouds/self-built environments and Tencent Cloud
  • Distributed transaction
  • Supported only in Tencent Cloud private network
  • Not supported between other clouds/self-built environments and Tencent Cloud
  • Change data capture (CDC)SupportedSupportedSupported
    Change tracking (CT)SupportedSupportedSupported
    Windows domain account loginNot supportedNot supportedNot supported
    MailingNot supportedNot supportedNot supported
    SQL Server Integration Services (SSIS)SupportedSupportedSupported
    SQL Server Analysis Services (SSAS)Not supportedNot supportedNot supported
    SQL Server Reporting Services (SSRS)Not supportedNot supportedNot supported
    R language serviceNot supportedNot supportedNot supported
    Common Language Runtime (CLR) integrationNot supportedNot supportedNot supported
    Async messagingNot supportedNot supportedNot supported
    Policy managementNot supportedNot supportedNot supported
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support