2.5

Table Of Contents
VMware, Inc. 39
Chapter 4 Configuration Options for ACE Management Server
Set Up an External Database
Beforeyoubegin,makesurethatyouhaveoneofthefollowingsupporteddatabase
servers:
WindowsbasedserversMicrosoftSQLServer2000orhigher;
Oracle Database 10g
IfyouuseaMicrosoftSQLServerdatabase,thedatabasemustbehostedona
systemthatusesthesamelocaleasthesystemthathostsACEManagementServer.
Forexample,ifACEManagementServerisinstalledonaJapanese
system,the
databaseservermustalsobeinstalledonaJapanesesystemandmustuseJapanese
collation.
LinuxbasedserversPostgreSQL7.4orhigher;RedHatEnterpriseLinux
AdvancedServer4.5orhigher.
BeforeyouinstallthedatabaseonaLinuxhost,makesuretheunixODBCRPMpackage
isinstalledontheLinuxsystem.VMwarerecommendsthatyouupdatethepackageto
thelatestversionreleasedfor
yourspecificLinuxdistribution.TheunixODBCpackage
providesanODBCAPItoprogramsrunningonLinuxsystemsthatissimilartothe
WindowsODBCAPI.
Thepackagecontainsthelibodbcsharedlibrary,providingtheODBCDriverManager
APItootherprograms,asetofconfigurationutilities,andODBCdriversforpopular
databases.OnbothRedHatEnterpriseLinuxandSUSELinuxEnterpriseServer 9,the
ODBCdriverforPostgreSQLisincludedintheunixODBCbinarydistributionpackage.
Also,makesuretheunixODBC-gui-qt packageisinstalled(thisutilityisincludedin
theRedHatEnterpriseLinuxunixODBCpackage).Thispackageisrequiredtouse
the
ODBCConfigX11graphicalconfigurationtoolforsettingupadatasourcename(DSN).
To set up an external database
1Installadatabaseserveronahost.
TheexternaldatabasedoesnothavetobeinstalledonthesameserverasACE
ManagementServer,butitmustbeinstalledonthe sameplatform.Forexample,if
ACE
ManagementServerisinstalledonaWindowshost,thedatabaseservermust
alsobeinstalledonaWindowshost.
ACEManagementServercreatesthedatabaseschemaautomaticallyifproper
accessrightsaregranted.