AlwaysOn Availability Group Considerations

Parent Previous Next



Managing User Account Information


When a user wishes to install Workbench Server database(s) to an AlwaysOn Availability Group as availability databases, certain considerations should be made.


Important Note:

This isn't intended to be a guide for configuring an AlwaysOn Availability Group. This guide is assuming that an AlwaysOn Availability Group has already been properly configured and the user wishes to add the Pragmatic Works databases to an existing availability group as availability database(s).


Server Installation

Before beginning the installation process of Workbench Server, the users that will be set to run each of the application pools must have permission to connect to the availability group through the availability group listener.


Important Note:

When installing Workbench Server with the intent of using an AlwaysOn Availability Group, the application pools must be set to run as a specific user and cannot be configured to run as either the Application Pool Identity or Network Services.


Once the user(s) that will be running the application pools have been granted permission to connect to the availability group through the availability group listener, installation of Workbench Server can begin.


Installation of Workbench Server will follow the default setup instructions with several noticeable differences:


1.   On Step 5 ensure that the Workbench Server application pool is set to run as the user that was originally configured to have permission to connect to the availability group through the availability group listener

2.   On Step 6 ensure that the User and Administration database is configured so that its server setting is set to point to the availability group listener


3.   On Step 7 ensure that the BI xPress Server application pool is set to run as the user that was originally configured to have permission to connect to the availability group through the availability group listener

4.   On Step 8 ensure that the BI xPress database is configured so that its server setting is set to point to the availability group listener


5.   On Step 9 ensure that the DOC xPress Server application pool is set to run as the user that was originally configured to have permission to connect to the availability group through the availability group listener

6.   On Step 10 ensure that the DOC xPress database(s) are configured so that their server settings are set to point to the availability group listener

7.   On Step 11 ensure that the DOC xPress Data Handler Service is set to run as the user that was originally configured to have permission to connect to the availability group through the availability group listener

8.   On Step 13 ensure that the LegiTest database is configured so that its server setting is set to point to the availability group listener


Once Workbench Server installation has been completed, creation of the BI xPress, DOC xPress, LegiTest, and Workbench Server databases will occur automatically on the primary availability replica and the user can continue on to adding the databases to the availability group as availability databases.


Adding the databases to the Availability Group

Once the database(s) have been created, the database(s) can now be added as availability database(s) to the availability group. This is done in the exact same way a user would add any other database to an availability group:


1.   Within the database properties, ensure that the databases' recovery model is set to "Full"


2.   Create a network share that each availability replica has permissions to access


3.   Create a full back up of each database on the network share created in Step 2

4.   Once all of the databases have a full back up located on a network share, expand "AlwaysOn High Availability" within management studio's object explorer

5.   Right-click on the availability group that the user wishes to add the database(s) to and select "Add Database..."



6.   Walk through the steps within the "Add Database to Availability Group" wizard, ensuring the database(s) selected meet all of the prerequisites. On the "Select Data Synchronization" page, select "Full" and specify the network share created in Step 2 as the location accessible by all replicas


Once the BI xPress, DOC xPress, LegiTest and / or Workbench Server database(s) have been added to the availability group as availability databases, whenever a user wishes to connect to the databases, the user should connect through the availability group listener.