6.7

3 If your existing database is Microsoft SQL Server, and you want to upgrade to a newly supported
Microsoft SQL Server database, such as Microsoft SQL Server 2012, upgrade your Microsoft SQL
Server database before upgrading vCenter Server.
You do not need to install a new vCenter Server instance if your existing database is Microsoft SQL
Server.
When you migrate the database from Microsoft SQL Server 2005 to Microsoft SQL Server 2008 R2-
SP2 or later, set the compatibility level of the database to 100.
4 Verify that permissions are set correctly.
5 Verify that passwords are current and not set to expire soon.
6 Verify that JDK 1.6 or later is installed on the vCenter Server machine.
7 Verify that the sqljdbc4.jar file is added to the CLASSPATH variable on the machine where
vCenter Server is to be upgraded.
If the sqljdbc4.jar file is not installed on your system, the vCenter Server installer installs it.
8 Verify that your system database source name is using the Microsoft SQL Server Native Client 10 or
11 driver.
9 If you choose to remove the DBO role and migrate all objects in the DBO schema to a custom
schema, you must grant the required permissions.
a Grant the required permissions to the vCenter Server user in the vCenter Server database.
b Grant the required permissions to the user in the MSDB database.
10 Make a full backup of the vCenter Server database.
Your database is prepared for the vCenter Server upgrade.
Use a Script to Create and Apply a Microsoft SQL Server Database Schema
and Roles
In this method of configuring the SQL database, you create the custom schema VMW, instead of using
the existing dbo schema. You must also enable Database Monitoring for a user before you install
vCenter Server with an embedded or external Platform Services Controller.
This method requires that you create new database roles and grant them to the database user.
Prerequisites
To make sure you have the proper roles and permissions before upgrading vCenter Server, update the
SQL Server database and users for vCenter Server.
Procedure
1 Log in to a Microsoft SQL Server Management Studio session as the sysadmin or a user account with
sysadmin privileges.
vCenter Server Upgrade
VMware, Inc. 46