5.0

VMware vCenter Operations Enterprise Installation and Administration Guide
14 VMware, Inc.
cTypethesuperusernameandpasswordthatvCenterOperationsManagerEnterprisewillusewhen
itconnectstoSQLServer.Thedatabaseiscratedunderthisusername
d SelectMakeadatabase.Thedefaultconfigurationvaluesworkformostinstallations.Donotclick
AdvancedunlessaVMwaresupportrepresentativeinstructsyou
todoso.
eClickRun.
4Whentheprocesshasfished,clickOK.
5InSQLServerManagementStudio,confirmthatthenewdatabaseexists.
Prepare a SQL Database that Requires Regular 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.
3InSQLServer,createadatabasetoholdthevCenterOperationsManagerEnterpriseschemaanddata.
Youcangiv e thedatabaseanyname.Keeparecordofthedatabasename.Youwillneedthenamewhen
youconfigurethedatabase.
4InSQLServerManagementStudiooranothertoolthatruns
SQLscripts,runcreateuser.sqlunderthe
databasethatyoucreated.Usethesamesuperuserprivilegesthatyouusedtocreatethedatabase.
ThescriptcreatesanSQLServeruserthathasthenamevcopsandadefaultpassword.Youcanchange
theusernameandpasswordaftertheuseris
created.
5Run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.
cTypetheusernameandpasswordfortheSQLServeruserthatwascreatedwhenyouran
createuser.sql.Thedatabaseiscreatedunderthis
username
d SelectUpgradeanexistingadatabase.Thedefaultconfigurationvaluesworkformostinstallations.
DonotclickAdvancedunlessaVMwaresupportrepresentativeinstructsyoutodoso.
eTypethenameofthedatabasethatyoucreatedwhenyoucreatedtoholdthevCenterOperations
ManagerEnterpriseschemaand
data.