Specifications

Microsoft SQL Database Set to Unsupported Compatibility Mode Causes
vCenter Server Installation or Upgrade to Fail
vCenter Server installation with a Microsoft SQL database fails when the database is set to compatibility
mode with an unsupported version.
Problem
The following error message appears: The DB User entered does not have the required permissions
needed to install and configure vCenter Server with the selected DB. Please correct the following
error(s): %s
Cause
The database version must be supported for vCenter Server. For SQL, even if the database is a supported
version, if it is set to run in compatibility mode with an unsupported version, this error occurs. For example,
if SQL 2008 is set to run in SQL 2000 compatibility mode, this error occurs.
Solution
u
Make sure the vCenter Server database is a supported version and is not set to compatibility mode with
an unsupported version. See “vCenter Server Database Patch and Configuration Requirements,” on
page 33
vCenter Server Upgrade Fails When You Restore a Microsoft SQL 2000 Backup
to the vCenter Server Database
A vCenter Server upgrade fails if you restore a Microsoft SQL 2000 database backup to the vCenter Server
database.
Problem
When the failure occurs, the following error message appears: DBuser entered doesn't have the required
permissions to install and configure vCenter Server with the selected DB.
Cause
This problem can occur when you upgrade to vCenter Server from VirtualCenter 2.x. VirtualCenter 2.x
supports SQL 2000, which VMware does not support for vCenter Server 5.0. When you restore a backup
from SQL Server 2000 on SQL Server 2005, the restored database is set to compatibility level 80, which is
compatible with SQL Server 2000. The minimum supported compatibility level for vCenter Server 5.0
databases is 90, which is compatible with SQL Server 2005.
Solution
u
Before you upgrade to vCenter Server, change the compatibility level to 90, for compatibility with SQL
Server 2005, or to 100, for compatibility with SQL Server 2008.
ALTER DATABASE AdventureWorks SET SINGLE_USER;
GO
EXEC sp_dbcmptlevel AdventureWorks, 90;
GO
ALTER DATABASE AdventureWorks SET MULTI_USER;
GO
vSphere Upgrade
40 VMware, Inc.