VDB Provision Fails Due to Msg 35221: Always On Availability Groups replica manager is disabled on this instance of SQL Server (KBA10922)

Issue

During VDB Provision, the following error occurs during recovery:

Recovery failed for virtual database "VDB_DatabaseName"

The following error message is present in the Provision job error:

Changed database context to 'master'.
Msg 35221, Level 16, State 1, Server ServerName\InstanceName, Line 1
Could not process the operation. Always On Availability Groups replica manager
   is disabled on this instance of SQL Server. Enable Always On Availability
   Groups, by using the SQL Server Configuration Manager. Then, restart the SQL
   Server service, and retry the currently operation. For information about how
   to enable and disable Always On Availability Groups, see SQL Server Books
   Online.


Removing seed VDB files from temporary directory C:\Program Files\Delphix\Delphi
   xConnector\d999999999-a999-3666-a000-b11111111111-vdb-6\DATA\_dlpxDRE
die : Error: Failed to create seed database.
At C:\Program Files\Delphix\DelphixConnector\d999999999-a999-3666-a000-b11111111111-vdb-6\SCRIPT\CreateSeedDB.ps1:104 char:5
+     die "Failed to create seed database."
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error],
   WriteErrorException
+ FullyQualifiedErrorId :
Microsoft.PowerShell.Commands.WriteErrorException,die

die : Error: create_seed_vdb failed

• The message refers to the Always On Availability Groups (AG) replica manager.
• In this specific case, no AG is involved. 

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies

Date	Release
Feb 21, 2024	20.0.0.0
Jan 25, 2024	19.0.0.0
Dec 20, 2023 | Jan 10, 2024	18.0.0.0 | 18.0.0.1
Nov 21, 2023	17.0.0.0
Oct 18, 2023	16.0.0.0
Sep 21, 2023	15.0.0.0
Aug 24, 2023	14.0.0.0
Jul 24, 2023	13.0.0.0
Jun 21, 2023	12.0.0.0
May 25, 2023	11.0.0.0
Apr 13, 2023	10.0.0.0 | 10.0.0.1
Mar 13, 2023 | Mar 20, 2023	9.0.0.0 | 9.0.0.1
Feb 13, 2023	8.0.0.0
Jan 12, 2023	7.0.0.0
Releases Prior to 2023
Major Release	All Sub Releases
6.0	6.0.13.0, 6.0.13.1, 6.0.14.0, 6.0.15.0, 6.0.16.0, 6.0.17.0, 6.0.17.1, 6.0.17.2

Resolution

Upgrade SQL Server 2022 to the latest build.

Troubleshooting

The Msg 35221 issue is a well known bug of the first SQL Server 2022 release.

• This issue occurred due to the version of the database server. I this specific case, SQL Server 2022 RTM Version with Build number 16.0.1000.6. 
• According to the following article, there is a bug in this version: SQL 2022 Bug - FILESTREAM.  
• To find out the current SQL Server version, follow the instructions from the following Microsoft Learn page: Determine which version and edition of SQL Server Database Engine is running.
• To see the builds available for the SQL Server: https://sqlserverbuilds.blogspot.com/