5.0

Table Of Contents
VMware, Inc. 15
Chapter 4 vCenter Operations Manager Enterprise Database Configuration
fClickRun.
6Whentheprocesshasfished,clickOK.
7InSQLServerManagementStudio,confirmthatthenewdatabaseexists.
Prepare a SQL Database When You Cannot Run Executable Files
Ifyoucannotrunexecutablefiles,youcanprepareanSQLdatabaseforvCenterOperationsEnterpriseby
runningSQLscripts.TheSQLscriptsareincludedinthevCenterOperationsManagerEnterpriseinstallation
package.
Prerequisites
FamiliarizeyourselfwiththedatabaseserverrequirementsforvCenterOperationsManagerEnterprise.
See“DatabaseServerRequirements”onpage 9.
InstallSQLServer.
CreateaWindowsauthenticationaccountoranSQLauthenticationaccountthathassufficientprivileges
tocreateanewdatabaseandnewSQLuser.
ObtainthevCenterOperationsManagerEnterpriseinstallationpackage.
Procedure
1IfyouareusingWindowsauthenticationforSQLserver,logonasauserwithenoughprivilegestocreate
adatabase.
2Extractthefilesfromvcops_sqlserver.ziptoanyavailabledirectory.
vcops_sqlserver.zipislocatedinthesamefolderasthevCenterOperationsManagerEnterprise
executable
files.
3InSQLServer,createadatabasetoholdthevCenterOperationsManagerEnterpriseschemaanddata.
Youcangiv e thedatabaseanyname.Keeparecordofthedatabasename.Youwillneedthenamewhen
youconfigurethedatabase.
4InSQLServerManagementStudiooranothertoolthatrunsSQL
scripts,runcreateuser.sqlunderthe
databasethatyoucreated.Usethesamesuperuserprivilegesthatyouusedtocreatethedatabase.
ThescriptcreatesanSQLServeruserthathasthenamevcopsandadefaultpassword.Youcanchange
theusernameandpasswordaftertheuseriscreated.
5 Attachto
thedatabaseyoucreatedtoholdthevCenterOperationsManagerEnterpriseschemaanddata.
UsetheusernameandpasswordfortheSQLServeruserthatwascreatedwhenyouran
createuser.sql.
6Runthevcops_SQLServer_
xxxx
Schema.sqlscript.
7Runthevcops_SQLServer_
xxxx
Data.sqlscript.
8InSQLServerManagementStudio,verifythatthenewdatabaseexists.
Preparing an Oracle Database on a Windows Host
IftheOracledatabaseisonaWindowshost,youcanrunabatchfiletopreparethedatabasetostorevCenter
OperationsEnterprisedata.ThebatchfileisincludedinthevCenterOperationsManagerEnterprisee
installationpackage.
Prerequisites
Beforeyoubegintheprocessbelow,makesureyouhavedonethefollowing:
Familiarizeyourselfwiththedatabaseserverrequirements.See“DatabaseServerRequirements”on
page 9.