It is possible to upgrade to vCenter Server 6.0 when configured with a supported SQL Express database and not have the database migrated to vPostgres
.
Note: As SQL Express is an external database solution, you may need to reach out to database vendor for database solution management or core SQL issues.
Method 1
Method 2
Before performing an upgrade of vCenter Server to version 6.0, configure the default SQL instance to use SQL Server and Windows Authentication mode and update vCenter Server to use a SQL account to connect to the vCenter Server database.
To do this, perform these steps:
- Enable SQL Server and Windows Authentication
- Connect to the SQL instance hosting the vCenter using SQL Management Studio.
- Right-click on the instance (example: localhost\vim_sqlexp) and select properties.
- Select security.
- Ensure SQL Sever and Windows Authentication mode is enabled. Changing this setting will require a restart of the SQL instance for the change to take affect.
- Select SQL user to connect with vCenter Server
If the
SA account already exists, this account can be used. Other wise a new SQL account needs to be created.
- Connect to the SQL instance hosting the vCenter database.
- Expand Security.
- Expand logins.Right-click SA user and click properties.
- Under General the SA user password can be set.
- Under Status ensure login is set to enabled.
- Configure vCenter Server to use a SQL account to connect to the vCenter Server database
- Stop the VMware Virtual Center Server Service.
- Ensure a backup of the vCenter database has been taken.
- Update the ODBC connection on vCenter Server
- As an administrator, click Start > Control Panel > Administrative Tools > Data Sources (ODBC).
- Click the System DSN tab.
- Under System Data Sources, select the Data Source that the vCenter Server is using, as noted in the previous section of this article.
- Click Configure.
- On the Configure pane you see the name of the configured database server in the server text box.
- Click Next.
- Enter the appropriate log in credentials on the next page.
- Click Next.
- On this pane, you see the database that has been configured. To change the database, ensure that the checkbox for Change the default database to is selected, and select the database that you want to use for vCenter Server.
- Click Next.
- Click Next on the next screen, making no changes.
- Click Finish.
- Click Test Data Source to verify the information entered.
- When the test completes, review the information presented and click OK.
- If the test was successful, click OK to exit the wizard. If the test did not complete successfully, click Cancel and review the information entered to ensure it is valid.
- After the test is successful, click OK to exit the ODBC Data Source Administrator window.
- Update the vCenter server Configuration
- Click Start > Run, type regedit, and click OK. The Registry Editor window opens.
- Navigate to HKEY_LOCAL_MACHINE > SOFTWARE > VMware, Inc > VMware VirtualCenter.
- Modify the key DbInstanceName and remove the current Value data. Do not delete this key.
- Modify the key DbServerType and change the Value data from Bundled to Custom.
- Navigate to HKEY_LOCAL_MACHINE > SOFTWARE > VMware, Inc > VMware VirtualCenter > DB.
- Modify key 2 and add the vCenter Server user, for example sa.
- Change the database password stored in the registry to allow the user to update the ODBC information without reinstalling vCenter Server.
- Click Start > Run, type cmd, and click OK. The Command Prompt window opens.
- Run this command to set the password for the vCenter Server database:
C:\Program Files\VMware\Infrastructure\VirtualCenter Server\vpxd.exe -p
Note: This is the default path to the vCenter Server installation directory. Change the path appropriately, if required.
- Start vCenter Server Service and log in to verify that the host and virtual machine inventory is visible.