5.0

VMware, Inc. 13
4
BeforeyoucaninstallvCenterOperationsManagerEnterprise,youmustcreateadatabaseineitherMicrosoft
SQLServerorOracletosorethevCenterOperationsManagerEnterprisedata.Thischaptercontainsthe
followingsections:
 “PrepareaSQLDatabasethatRequiresSuperUserAccess”onpage 13
 “PrepareaSQLDatabasethatRequiresRegularUserAccess”onpage 14
 “PrepareaSQLDatabaseWhenYouCannotRunExecutableFiles”onpage 15
 “PreparinganOracleDatabaseonaWindowsHost”onpage 15
Prepare a SQL Database that Requires Super User Access
Ifyoucanrunexecutablefiles,andyourconfigurationandsecuritypoliciesallowvCenterOperations
ManagerEnterprisetouseausernamethathasdatabasecreationprivileges(asuperuser)whenit
communicateswithSQLServer,youcanpreparetheSQLdatabasebyrunningthe
vcops_SQL_Server_xxxx.exeprogram.Thisprogramisincluded
inthevCenterOperationsManager
Enterpriseinstallationpackage.
Prerequisites
 FamiliarizeyourselfwiththedatabaseserverrequirementsforvCenterOperationsManagerEnterprise.
See“DatabaseServerRequirements”onpage 9.
 InstallSQLServer.
 CreateaWindowsauthenticationaccountoranSQLauthenticationaccountthathassufficientprivileges
tocreateanewdatabaseandnewSQLuser.
 ObtainthevCenterOperationsManagerEnterpriseinstallationpackage.
Procedure
1IfyouareusingWindowsauthenticationforSQLServer ,loginasauserwhohassufficientprivilegesto
createadatabase.
2Extractthefilesfromvcops_sqlserver.ziptoanyavailabledirectory.
vcops_sqlserver.zipislocatedinthesamefolderasthevCenterOperationsManagerEnterprise

executablefiles.
3Runvcops_SQLServer_xxxx.exe.
aTypetheIPaddressofthedatabaseserver,ortypeip_address\instance_nametoselectaspecific
instanceofthedatabase.
b SelectSQLServerauthentication.
vCenter Operations Manager
Enterprise Database Configuration
4