Microsoft Configuration Manager

Sql Server Alwayson For A Highly Available Site Database

28 September 2026Feature update+2 / −2 lines

In brief

The guidance now requires TRUSTWORTHY for Configuration Manager 2603 and earlier, but says it isn't needed and should be skipped for version 2609 and later when loading SQLCLR assemblies.

What Intune admins need to know

Use the instruction that matches the Configuration Manager version when configuring the site database.

This summary was assembled from the tracked documentation change. Verify important details in the full Microsoft Learn article.

Documentation change

View full page diff

View on Microsoft Learn

The comparison below shows only the changed extract. Use the full-page view for complete context.

EXECUTE sp_configure 'max text repl size (B)', 2147483647
```

Set the database owner to the SA account. You don't need to enable this account.
~~Turn~~For Configuration Manager version 2603 and earlier, turn ON the TRUSTWORTHY setting:
```
ALTER DATABASE [CM_xxx] SET TRUSTWORTHY ON;
```
For version 2609 and later, you don't need to enable TRUSTWORTHY to load Configuration Manager SQLCLR assemblies. Skip this command when configuring the site database for these versions. For more information, see ~~the TRUSTWORTHY database property~~SQLCLR assembly trust.
Enable the Service Broker:

@@ -135,13 +135,13 @@ Configure the database of each replica with the following settings:     EXECUTE sp_configure 'max text repl size (B)', 2147483647
     ```
 - Set the database owner to the *SA account*. You don't need to enable this account.
-- Turn **ON** the **TRUSTWORTHY** setting:
+- For Configuration Manager version 2603 and earlier, turn **ON** the **TRUSTWORTHY** setting:
 
     ```SQL
     ALTER DATABASE [CM_xxx] SET TRUSTWORTHY ON;
     ```
 
-    For more information, see the [TRUSTWORTHY database property](/en-us/sql/relational-databases/security/trustworthy-database-property).
+    For version 2609 and later, you don't need to enable **TRUSTWORTHY** to load Configuration Manager SQLCLR assemblies. Skip this command when configuring the site database for these versions. For more information, see [SQLCLR assembly trust](../../../plan-design/configs/supported-configurations-for-sql-server#sqlclr-assembly-trust).
 - Enable the **Service Broker**:
 
     ```SQL