Installation guide

Prerequisites for Microsoft SQL Databases

To use a newly supported Microsoft SQL database, such as Microsoft SQL 2008, you do not need to perform

a clean installation of vCenter Server if your existing database is also Microsoft SQL Server. For example,

you can upgrade a Microsoft SQL Server 2000 database to Microsoft SQL Server 2005 or

Microsoft SQL Server 2008 and then upgrade VirtualCenter 2.5 Update 6 or higher to vCenter Server 5.0.

When you migrate the database from Microsoft SQL Server 2000 to Microsoft SQL Server 2005 or higher,

set the compatibility level of the database to 90.

JDK 1.6 must be installed on the vCenter Server machine. In addition, sqljdbc4.jar must be added to the

CLASSPATH variable on the machine where vCenter Server is to be upgraded. If it is not installed on your

system, the vCenterServer installer installs it. The JDK 1.6 installation might require Internet connectivity.

If you are upgrading from VirtualCenter 2.5 Update 6 with the bundled SQL Server 2005 Express (by

installing vCenter Server 5.0 on a different machine and keeping the database), you do not have to perform

a clean installation of vCenter Server.

Your system DSN must be using the SQL Native Client driver.

Grant the following permissions to the vCenter user in the vCenter database:

GRANT ALTER ON SCHEMA :: <schema> to <user>;

GRANT REFERENCES ON SCHEMA :: <schema> to <user>;

GRANT INSERT ON SCHEMA :: <schema> to <user>;

GRANT CREATE TABLE to <user>;

GRANT CREATE VIEW to <user>;

GRANT CREATE Procedure to <user>;

Grant the following permissions to the user in the MSDB database:

GRANT SELECT on msdb.dbo.syscategories to <user>;

GRANT SELECT on msdb.dbo.sysjobsteps to <user>;

GRANT SELECT ON msdb.dbo.sysjobs to <user>;

GRANT EXECUTE ON msdb.dbo.sp_add_job TO <user>;

GRANT EXECUTE ON msdb.dbo.sp_delete_job TO <user>;

GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO <user>;

GRANT EXECUTE ON msdb.dbo.sp_update_job TO <user>;

GRANT EXECUTE ON msdb.dbo.sp_add_category TO <user>;

GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO <user>;

GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO <user>;

Prerequisites for Oracle Databases

To use a newly supported Oracle database, such as Oracle 11g, you do not need to perform a clean

installation of vCenter Server if your existing database is also Oracle. For example, you can upgrade your

existing Oracle 9i database to Oracle 10g or Oracle 11g and then upgrade vCenter Server 4.x to vCenter

Server 5.0.

The JDBC driver file must be included in the CLASSPATH variable.

Either assign the DBA role or grant the following permissions to the user:

grant connect to <user>

grant resource to <user>

grant create view to <user>

grant create any sequence to <user>

grant create any table to <user>

vSphere Upgrade

32 VMware, Inc.