Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Upgrade to VMM 2016 or VMM 2012 R2 fails if AlwaysOn Availability Groups is enabled

Upgrade to VMM 2016 or VMM 2012 R2 fails if AlwaysOn Availability Groups is enabled

View products that this article applies to.

Symptoms

When you try to upgrade to Virtual Machine Manager 2016, the attempt may fail if the VMM database is using a Microsoft SQL Server database that leverages the AlwaysOn Availability Groups feature. In this situation, the following error is returned:

10:16:43:InnerException.Type: System.Data.SqlClient.SqlException, InnerException.Message: The operation cannot be performed on database "VirtualManagerDB" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.

↑ Back to the top

Cause

This issue occurs because VMM can't complete the necessary changes to the VMM database while it's configured to use the AlwaysOn Availability Groups feature.

↑ Back to the top

Resolution

Before you upgrade VMM, use the SQL Server Management Studio tool to remove the VMM database from the availability group.

After the upgrade is finished, complete the configuration of AlwaysOn Availability Groups for the database:
  1. Add the VMM database to the availability group. You can use SQL Server Management Studio to perform this task.
  2. On the secondary node computer in the cluster that's running SQL Server, create a new sign-in account:
    • Configure the sign-in name so that it's identical to the VMM service account name.
    • Include user mapping to the VMM database.
    • Configure the database owner credentials.
  3. Initiate a failover to the secondary node computer that's running SQL Server, and verify that you can restart the VMM service (scvmmservice).
  4. Repeat steps 2–3 for every secondary node in the cluster that's running SQL Server.
  5. If this is a high availability VMM setup, continue to install other high availability VMM nodes.
For more information about the steps to complete before and after you upgrade VMM, see the following TechNet resources:

Tasks to perform before beginning the VMM upgrade

Performing post-upgrade tasks in VMM

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 3198628
Revision : 2
Created on : 5/22/2017
Published on : 5/22/2017
Exists online : False
Views : 607