Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The information in this specification is applicable to the following Microsoft products or supplemental software. References to product versions include updates to those products.
Microsoft SQL Server 2019
Exceptions, if any, are noted in this section. If an update version, service pack or Knowledge Base (KB) number appears with a product name, the behavior changed in that update. The new behavior also applies to subsequent updates unless otherwise specified. If a product edition appears with the product version, behavior is different in that product edition.
Unless otherwise specified, any statement of optional behavior in this specification that is prescribed using the terms "SHOULD" or "SHOULD NOT" implies product behavior in accordance with the SHOULD or SHOULD NOT prescription. Unless otherwise specified, the term "MAY" implies that the product does not follow the prescription.
<1> Section 2.2.4.4: The "v1" value of the uriVersion parameter is supported only by SQL Server earlier than SQL Server 2019 Cumulative Update 9 (CU9).
<2> Section 2.2.5.1.1.1.4: The allowRunAsRoot element is not supported by SQL Server earlier than SQL Server 2019 Cumulative Update 5 (CU5). In SQL Server 2019 Cumulative Update 2 (CU2), SQL Server 2019 Cumulative Update 3 (CU3), and SQL Server 2019 Cumulative Update 4 (CU4), the equivalent element privileged was used. SQL Server 2019 and SQL Server 2019 Cumulative Update 1 (CU1) do not support this functionality.
<3> Section 2.2.5.1.1.1.4: The allowDumps element is not supported by SQL Server earlier than SQL Server 2019 CU5.
<4> Section 2.2.5.1.1.1.4: The allowNodeMetricsCollection element is not supported by SQL Server earlier than SQL Server 2019 CU5.
<5> Section 2.2.5.1.1.1.4: The allowPodMetricsCollection element is not supported by SQL Server earlier than SQL Server 2019 CU5.
<6> Section 2.2.5.1.1.1.4: The automountServiceAccountToken element is not supported by SQL Server earlier than SQL Server 2019 Cumulative Update 6 (CU6).
<7> Section 2.2.5.1.1.1.4.1: The security.activeDirectory element is not supported by SQL Server earlier than SQL Server 2019 CU2.
<8> Section 2.2.5.1.1.1.4.1: The security.activeDirectory.useInternalDomain element is not supported by SQL Server earlier than SQL Server 2019 CU2. In SQL Server 2019 and SQL Server 2019 CU1, the equivalent element security.useInternalDomain was used.
<9> Section 2.2.5.1.1.1.4.1: The useSubdomain element is not supported by SQL Server earlier than SQL Server 2019 CU5.
<10> Section 2.2.5.1.1.1.4.1: The security.activeDirectory.ouDistinguishedName element is not supported by SQL Server earlier than SQL Server 2019 CU2. In SQL Server 2019 and SQL Server 2019 CU1, the equivalent element security.ouDistinguishedName was used.
<11> Section 2.2.5.1.1.1.4.1: The subdomain element is not supported by SQL Server earlier than SQL Server 2019 CU5.
<12> Section 2.2.5.1.1.1.4.1: The accountPrefix element is not supported by SQL Server earlier than SQL Server 2019 CU5.
<13> Section 2.2.5.1.1.1.4.1: The security.activeDirectory.realm element is not supported by SQL Server earlier than SQL Server 2019 CU2. In SQL Server 2019 and SQL Server 2019 CU1, the equivalent element security.realm was used.
<14> Section 2.2.5.1.1.1.4.1: The security.activeDirectory.domainDnsName element is not supported by SQL Server earlier than SQL Server 2019 CU2. In SQL Server 2019 and SQL Server 2019 CU1, the equivalent element security.domainDnsName was used.
<15> Section 2.2.5.1.1.1.4.1: The accountPasswordsNeverExpire element is not supported by SQL Server earlier than SQL Server 2019 Cumulative Update 7 (CU7).
<16> Section 2.2.5.1.1.1.4.1: The netbiosDomainName element is not supported by SQL Server earlier than SQL Server 2019 CU9.
<17> Section 2.2.5.1.1.1.4.1.1: The security.activeDirectory.dnsIpAddresses element is not supported by SQL Server earlier than SQL Server 2019 CU2. In SQL Server 2019 and SQL Server 2019 CU1, the equivalent element security.dnsIpAddresses was used.
<18> Section 2.2.5.1.1.1.4.1.2: The security.activeDirectory.domainControllerFullyQualifiedDns element is not supported by SQL Server earlier than SQL Server 2019 CU2. In SQL Server 2019 and SQL Server 2019 CU1, the equivalent element security.domainControllerFullyQualifiedDns was used.
<19> Section 2.2.5.1.1.1.4.1.3: The security.activeDirectory.clusterAdmins element is not supported by SQL Server earlier than SQL Server 2019 CU2. In SQL Server 2019 and SQL Server 2019 CU1, the equivalent element security.clusterAdmins was used.
<20> Section 2.2.5.1.1.1.4.1.4: The security.activeDirectory.clusterUsers element is not supported by SQL Server earlier than SQL Server 2019 CU2. In SQL Server 2019 and SQL Server 2019 CU1, the equivalent element security.clusterUsers was used.
<21> Section 2.2.5.1.1.1.4.1.5: The security.activeDirectory.appOwner element is not supported by SQL Server earlier than SQL Server 2019 CU2. In SQL Server 2019 and SQL Server 2019 CU1, the equivalent element security.appOwner was used.
<22> Section 2.2.5.1.1.1.4.1.6: The security.activeDirectory.appUsers element is not supported by SQL Server earlier than SQL Server 2019 CU2. In SQL Server 2019 and SQL Server 2019 CU1, the equivalent element security.appUsers was used.
<23> Section 2.2.5.1.5.1.2: The replicas element is not supported by SQL Server earlier than SQL Server 2019 CU9.
<24> Section 2.2.5.1.5.1.2.1: The availabilityMode element is not supported by SQL Server earlier than SQL Server 2019 CU9.
<25> Section 2.2.5.1.5.1.2.2: The replicaRole element is not supported by SQL Server earlier than SQL Server 2019 CU9.
<26> Section 2.2.5.1.5.1.2.3: The synchronizationStatus element is not supported by SQL Server earlier than SQL Server 2019 CU9.
<27> Section 2.2.5.6: The Config resource type is not supported by SQL Server earlier than SQL Server 2019 CU9.
<28> Section 2.2.5.6.1: The Apply Settings Request schema is not supported by SQL Server earlier than SQL Server 2019 CU9.
<29> Section 2.2.5.6.2: The Set Settings Response schema is not supported by SQL Server earlier than SQL Server 2019 CU9.
<30> Section 2.2.5.6.3: The Get Cluster Settings schema is not supported by SQL Server earlier than SQL Server 2019 CU9.
<31> Section 2.2.5.6.4: The Get Service Configuration Response Settings schema is not supported by SQL Server earlier than SQL Server 2019 CU9.
<32> Section 2.2.5.6.5: The Get Resource Settings schema is not supported by SQL Server earlier than SQL Server 2019 CU9.
<33> Section 2.2.5.7: The KMS resource type is not supported by SQL Server earlier than SQL Server 2019 Cumulative Update 11 (CU11).
<34> Section 2.2.5.7.1: The Update KMS Configuration Request schema is not supported by SQL Server earlier than SQL Server 2019 CU11.
<35> Section 2.2.5.7.2: The Show KMS Configuration Response schema is not supported by SQL Server earlier than SQL Server 2019 CU11.
<36> Section 3.1.5.7: The Config API is not supported by SQL Server earlier than SQL Server 2019 CU9. Note that as such, the methods of the Config API do not support the "v1" value of the uriVersion parameter.
<37> Section 3.1.5.7.1: The Apply Configuration Settings method is not supported by SQL Server earlier than SQL Server 2019 CU9.
<38> Section 3.1.5.7.2: The Revert Pending Configuration Settings method is not supported by SQL Server earlier than SQL Server 2019 CU9.
<39> Section 3.1.5.7.3: The Set Cluster Configuration Settings method is not supported by SQL Server earlier than SQL Server 2019 CU9.
<40> Section 3.1.5.7.4: The Get Cluster Configuration Settings method is not supported by SQL Server earlier than SQL Server 2019 CU9.
<41> Section 3.1.5.7.5: The Set Service Configuration Settings method is not supported by SQL Server earlier than SQL Server 2019 CU9.
<42> Section 3.1.5.7.6: The Get Service Configuration Settings method is not supported by SQL Server 2019 CU9.
<43> Section 3.1.5.7.7: The Set Resource Configuration Settings method is not supported by SQL Server earlier than SQL Server 2019 CU9.
<44> Section 3.1.5.7.8: The Get Resource Configuration Settings method is not supported by SQL Server earlier than SQL Server 2019 CU9.
<45> Section 3.1.5.8: The KMS API is not supported by SQL Server earlier than SQL Server 2019 CU11.
<46> Section 3.1.5.8.1: The Update KMS Configuration method is not supported by SQL Server earlier than SQL Server 2019 CU11.
<47> Section 3.1.5.8.2: The Show KMS Configuration method is not supported by SQL Server earlier than SQL Server 2019 CU11.