Preparing a database for vSphere Update Manager

Before you install vSphere Update Manager, you need to decide whether to use an existing database server or use the installer-packaged SQL Express.

If you choose to use an existing database server then you will need to create a separate database for vSphere Update Manager.

The database user should have a sysadmin or db_owner role for SQL.

For a list of compatible databases with vSphere Update Manager, you can use the VMware Product Interoperability Matrixes.

Note

For more details, visit http://www.vmware.com/resources/compatibility/sim/interop_matrix.php

Select Solution/Database Interoperability. In step 1, select the product as VMware vCenter Update Manager Version 5.1 and in step 2, the Add Database step, add Any.

How to do it...

The following instructions will help you to create a new SQL database and configure ODBC connectivity to it.

1. Connect to the Microsoft SQL Server Management Studio and right-click on the Databases folder item and click on...