Adjust vCenter Server for usage on SQL Server cluster

vSphere 5.5 added support for the usage of Microsoft SQL Server cluster for the vCenter Server database. Previously the database could only be installed on a non-clustered SQL Server instance.

VMware added a KB article titled Enabling Microsoft SQL Clustering Service for VMware vCenter Server 5.5 database (2059560)

To enable the Microsoft SQL Clustering Service functionality on your vCenter Server:
  1. Connect to vCenter Server and navigate to C:\ProgramData\VMware\VMware VirtualCenter\.
  2. Create a backup of the current vpxd.cfg file.

    Note: Do not skip this step.

  3. Stop the VMware VirtualCenter Server service. For more information, see Stopping, starting, or restarting vCenter services (1003895).
  4. Open the vpxd.cfg file in a text editor.
  5. Set the recoverForAllError parameter to true:

    <vpxd>
    <odbc>
    <recoverForAllError>true</recoverForAllError>
    </odbc>

    </vpxd>

    Note: Add the above entry if it is not present in vpxd.cfg file already.

  6. Save and close the vpxd.cfg file.
  7. Start the VMware VirtualCenter Server service.

Supported vCenter Server high availability options (1024051)

Add a Comment

Your email address will not be published. Required fields are marked *

Current ye@r *