2.5

Table Of Contents
ACE Management Server Administrator’s Manual
40 VMware, Inc.
2Configurethedatabase.
Ensurethatyouhaveadedicateddatabaseandauseraccountthathasfullaccess
tothisdatabase,includingrightstocreatetables.Donotgivethisdatabaseuser
permissionsthatitdoesnotneed.Forexample,youmightnotwanttogivethis
accountreadorwrite
permissiontootherdatabasesthatyourRDBMSmanages.
AlltablesthatarecreatedinthedatabasehaveanamestartingwithaPolicyDb_
prefixandindexeswithPdbIns_orPdbLf_prefixes.YoumightprovideACE
ManagementServerwithaDSNtoadatabasethatitshareswithsomeother
application,if
thedatabasecountisatapremium.
3 (Optional)IfACEManagementServerisgoingtoconnecttothedatabaseoverthe
network(TCPsocketconnection),ensurethatthefollowingareinplace:
TCPconnectivityisenabledinthedatabaseconfigurationoptions.
TheTCPconnectionisnotblockedbyfirewallsettingsonthedatabaseserver
ortheACEManagementServerhost.
IfyouareusingaPostgreSQLdatabase,configureperuserpermissionto
connecttothedatabaseoverthenetwork.Configurethatpermissioninthe
pg_hba.conf file,whichislocatedintherootfolderofyourdatabase.
4 (Optional)OntheACEManagementServermachine,toverifytheservers
connectivitytothedatabasewith
theconfiguredusercredentials,runa
commandlineorgraphicalSQLtool.
Examplesofsuchtoolsaresqlcmd.exeforSQLServer,sqlplus.exeforOracle,
andpsqlforPostgresSQL.Fordatabaseconfigurationandverification
instructions,seetherespectivedatabasedocumentation.
5OntheACEManagementServermachine,createaSystemDSNentry.
Creating a System DSN Entry for an External Database
TheonlyrequiredinformationinDSNconfigurationistheDSNname,serverIPaddress
orhostname,andthedatabasename.Youdonotneedtoprovideausernameand
passwordintheDSNconfiguration.Youprovideausernameandpasswordlater,
whenyouusetheACEManagementServer
Setupapplication.
EnsurethatyoucreateasystemDSNandnotauserDSN.IfyoucreateauserDSN,it
isvisibleonlytoyouruseraccount.ACEManagementServerrunsunderthelocal
systemaccount,sotheservercannotdetectoruseauserDSN.