Skip to content

Manually Set TRUSTWORTHY Database Property on Always On Systems#

For customers installing Critical Manufacturing on Always On availability groups it is necessary to manually set the trustworthy flag on the secondary replicas. For the Online, ODS and DWH databases follow this procedure:

  1. Failover to the node currently holding the secondary replica.
  2. Run the following command statement in SQL Management Studio:
ALTER DATABASE <Database Name> SET TRUSTWORTHY ON;