6.7

Table Of Contents
Your database is prepared for the vCenter Server upgrade.
What to do next
After the upgrade is complete, you can optionally remove the following permissions from the user profile:
create any sequence and create any table.
By default, the RESOURCE role has the CREATE PROCEDURE, CREATE TABLE, and CREATE
SEQUENCE privileges assigned. If the RESOURCE role lacks these privileges, grant them to the
vCenter Server database user.
Prepare Microsoft SQL Server Database Before Upgrading vCenter Server
Ensure that your Microsoft SQL Server database meets requirements, that you have the necessary
credentials, and that you complete any necessary cleanup or other preparation before upgrading
vCenter Server.
To remove the DBO role and migrate all objects in the DBO schema to a custom schema, see the
VMware knowledge base article at http://kb.vmware.com/kb/1036331.
To migrate the vCenter Server database from Microsoft SQL Express to Microsoft full SQL Server, see the
VMware knowledge base article at http://kb.vmware.com/kb/1028601.
Important You cannot use Integrate Windows for your authentication method if the vCenter Server
service is running under the Microsoft Windows built-in system account.
Prerequisites
Verify that you have confirmed basic upgrade interoperability before preparing your Microsoft SQL Server
database for upgrading vCenter Server. See Database Requirements for vCenter Server on Windows.
Verify that you have backed up your database. For information about backing up the vCenter Server
database, see the Microsoft SQL Server documentation.
To set database permissions correctly, see Database Permission Requirements for vCenter Server and
Use a Script to Create and Apply a Microsoft SQL Server Database Schema and Roles.
Procedure
1 Verify that your database meets the upgrade requirements. If necessary, upgrade the database to a
supported version.
2 If your database server is not supported by vCenter Server, perform a database upgrade to a
supported version or import your database into a supported version.
vCenter Server Upgrade
VMware, Inc. 45