How to Complete the Configuration of AlwaysOn Availability Groups for the Database
Updated: May 13, 2016
Applies To: System Center 2012 SP1 - Virtual Machine Manager, System Center 2012 R2 Virtual Machine Manager
If the Virtual Machine Manager (VMM) database was configured with AlwaysOn Availability Groups, after you upgrade VMM to System Center 2012 R2, you need to complete the configuration of AlwaysOn Availability Groups.
For important recommendations about AlwaysOn, see the “SQL Server and database” section of Preparing your environment for System Center 2012 R2 Virtual Machine Manager.
To complete the configuration of AlwaysOn Availability Groups
Add the VMM database to the availability group. You can use Microsoft SQL Server Management Studio to perform this task.
On the secondary node computer in the cluster that is running SQL Server, create new sign-in account as follows:
Configure the sign-in name so that it is identical to the VMM service account name.
Include user mapping to the VMM database.
Configure the database owner credentials.
Initiate a failover to the secondary node computer that is running SQL Server, and verify that you can restart the VMM service (scvmmservice).
Repeat the last two steps for every secondary node in the cluster that is running SQL Server.
If this is a high availability VMM setup, continue to install other high availability VMM nodes.