6.0.2

Table Of Contents
7 Verify that the sqljdbc4.jar le is added to the CLASSPATH variable on the machine where
vCenter Server is to be upgraded.
If the sqljdbc4.jar le 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 Locate the cleanup_orphaned_data_MSSQL.sql script in the ISO image and copy it to the Microsoft SQL
server.
11 Log in to your database.
a For Microsoft SQL Server Express, open a command prompt.
b For Microsoft SQL Server, log in to a Microsoft SQL Server Management Studio session as the
vCenter Server database user.
12 For Microsoft SQL Server Express, run the cleanup script.
sqlcmd -E -S localhost\VIM_SQLEXP -d VIM_VCDB -i pathcleanup_orphaned_data_MSSQL.sql
13 For Microsoft SQL Server, run the cleanup_orphaned_data_MSSQL.sql contents.
Make sure that you are connected to the database used by vCenter Server.
The cleanup script cleans any unnecessary data in your vCenter Server database.
14 Make a full backup of the vCenter Server database and Inventory Service 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 conguring 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.
Chapter 3 Before Upgrading vCenter Server
VMware, Inc. 57