SQL Always On for SQL Server 2012, 2014, 2016, 2017 and 2019
Citrix Provisioning™ supports the SQL Always On high availability and disaster recovery solution. Consider the following:
-
The Microsoft OLE DB Driver for SQL Server is required. It is installed when you install Citrix Provisioning server.
-
Citrix Provisioning is only aware of and interacts with Always On through the listener DNS name.
-
The database must be part of the pre-made high availability group.
-
The listener DNS name and high availability group are part of the procedures to create SQL Always On.
-
The soap/stream services user must be manually configured to have full permission to each SQL server part of the Always On configuration.
-
Citrix Provisioning is not aware of the individual SQL server/cluster behind SQL Always On.
Note:
See Supported Databases for XenApp and XenDesktop Components in the Knowledge Center for additional information about supported databases and clients.