VMware, Inc. 69
Chapter 6 Installing VMware Infrastructure Management
Beforeyoubeginthisprocedure,reviewtherequireddatabasepatchesspecifiedin
Table 2‐1,“SupportedDatabaseFormats,”onpage 19.Ifyoudonotprepareyour
databasecorrectly,theVirtualCenterinstallermightdisplayerrorandwarning
messages.
To prepare a SQL Server database to work with VirtualCenter
1OnyourMicrosoftSQLServer,createaSQLServerdatabaseusingEnterprise
Manageronthe
SQLServer.
2OnyourMicrosoftSQLServer,createaSQLServerdatabaseuserwithdatabase
operator(DBO)rights.
ThedefaultdatabasefortheDBOuseriswhatyoudefinedinStep 1.
Makesurethatthedatabaseuserhasthefollowingpermissions:
MicrosoftSQLServer2000–Makesurethat thedatabaseuserhasthe
db_ownerfixeddatabaseroleontheVirtualCenterdatabaseandtheMSDB
database.Thedb_ownerroleontheMSDBdatabaseisrequiredfor
installationandupgradeonly.Youcanrevokethisroleaftertheinstallationor
upgradeprocessis
completed.Do notgranttheSystemAdministratorsserver
roletothedatabaseuser.However,iftheSystemAdministratorsrolewas
previouslygrantedwhilethedatabasewasusedwithVirtualCenterServer
2.0.x,donotrevoketheSystemAdministratorsrole.Leaveitasis.
MicrosoftSQLServer2005–Makesurethatthedatabaseloginhaseitherthe
sysadminserverroleorthedb_ownerfixeddatabaseroleontheVirtualCenter
databaseandontheMSDBdatabase.Thedb_ownerroleontheMSDB
databaseisrequiredforinstallationandupgradeonly.Youcanrevokethisrole
aftertheinstallationorupgradeprocessiscomplete.
3OnyourVirtualCenter Server,opentheWindowsODBCDataSource
Administrator.
4 SelectSettings>ControlPanel>AdministrativeTools>DataSources(ODBC).
5 SelecttheSystemDSNtab.
6TomodifyanexistingSQLServerODBCconnection:
a SelecttheappropriateODBCconnectionfromtheSystemData
Sourcelist
andclickConfigure.
bProceedwithStep 8.
