The purpose of this article is to explain the functionality of SQL Server AlwaysOn in relation to Citrix Provisioning Services (PVS).

The SQL Server AlwaysOn Availability Groups feature:

• Is a high-availability solution from Microsoft SQL - that provides an alternative to database mirroring.
• Availability Groups are configured to support a set of read-write primary databases and multiple secondary databases.

Instructions

Configuring PVS for AlwaysOn

Below steps are to be followed to configure the PVS Servers to connect to the SQL AlwaysOn Listener.

The SQL Listener acts like a Virtual IP (VIP) so that SQL Clients always connect to the same Virtual SQL Instance.

To configure PVS to connect to the AlwaysOn SQL Listener:

1. Verify the DNS Name or IP of the SQL Listener on the SQL Server Management Studio.

2. Run the Configuration Wizard on the First PVS Server.

3. Follow the Wizard without changing any of the options until you reach the “Farm Configuration” step.

4. Select Join existing farm.

5. In the next step of the Wizard, change the current SQL Server address for the address of the SQL Listener and the correct port.

6. Continue and finish the Configuration Wizard.

Repeat the steps for each of the PVS Servers in the Farm.

Note: The required database permissions for the service account used for Stream and Soap services on database  are:

• db_datareader

• db_datawriter

• ​execute permissions on stored procedures

Citrix PVS SQL Always on configuration reference edoc - https://docs.citrix.com/en-us/provisioning/1912-ltsr/advanced-concepts/configure-sql-server-always-on