2.7

Table Of Contents
VMware, Inc. 29
Chapter 4 Configuration Options for ACE Management Server
3 (Optional)IfACEManagementServerisgoingtoconnecttothedatabaseoverthenetwork(TCPsocket
connection),ensurethatthefollowingareinplace:
TCPconnectivityisenabledinthedatabaseconfigurationoptions.
TheTCPconnectionisnotblockedbyfirewallsettingsonthedatabaseserverortheACE
ManagementServerhost.
IfyouareusingaPostgreSQLdatabase,configureperuserpermissiontoconnecttothedatabase
overthenetwork.Configurethatpermissioninthepg_hba.conf file,whichislocatedintheroot
folderofyourdatabase.
4 (Optional)OntheACEManagementServermachine,toverifytheserversconnectivitytothedatabase
with
theconfiguredusercredentials,runacommandlineorgraphicalSQLtool.
Examplesofsuchtoolsaresqlcmd.exeforSQLServer,sqlplus.exeforOracle,andpsqlfor
PostgresSQL.Fordatabaseconfigurationandverificationinstructions,seetherespectivedatabase
documentation.
5OntheACEManagementServermachine,createaSystemDSNentry.
Creating a System DSN Entry for an External Database
TheonlyrequiredinformationinDSNconfigurationistheDSNname,serverIPaddressorhostname,andthe
databasename.YoudonotneedtoprovideausernameandpasswordintheDSNconfiguration.Youprovide
ausernameandpasswordlater,whenyouusetheACEManagementServer
Setupapplication.
EnsurethatyoucreateasystemDSNandnotauserDSN.IfyoucreateauserDSN,itisvisibleonlytoyour
useraccount.ACEManagementServerrunsunderthelocalsystemaccount,sotheservercannotdetectoruse
auserDSN.
Create a System DSN Entry for a Windows Database
Regardlessofwhetherthe
hostis32bitor64bit,youcreateaDSNentryfora32bitsystem.
Beforeyoubegin,todeterminethecorrectODBCdriver,seeyouroperatingsystemanddatabase
documentation.
To create a System DSN entry for a Windows database
1Dooneofthefollowing:
On32bithosts,usetheODBCDataSourcespluginbychoosingControl Panel>Administrative
Tools>DataSources(ODBC).
On64bithosts,navigateto%WINDIR%\syswow64\odbcad32.exeandusethatprogramtocreatea
SystemDSNentryfora32bitsubsystem.
ACEManagementServerdoesnotsupportODBCusinganSQLNativeClientdriveronWindows64bit
systems.
2 CreateanentrythatincludestheDSNname,serverIPaddressor
hostname,andthedatabasename.
3 (Optional)IftheDSNSetupwizardprovidesanoptiontotesttheconnection,verifythattheconnection
workswiththedatabaseusercredentials.
4MakeanoteofthedatabaseDSN,username,andpassword.
YoucannowusethebrowserbasedACEManagementServer
Setupapplicationtoconnecttothisdatabase.