3.1

Table Of Contents
View Manager Administration Guide
126 VMware, Inc.
IfaViewComposerdatabasedoesnotalreadyexistwithinyournetwork
environment,youmustcreateadatabaseanddatasourcename(DSN)tostore
ViewComposerdata.IfaViewComposerdatabasealreadyexistsinyour
environment,see“UsinganExistingViewComposerDatabase”onpage 147for
supplementaryinformationabout
howtousethisdatasource.
SeeTable 13,“DatabaseSupportandRequirementsforViewComposer,”on
page 22forinformationaboutsupporteddatabases.Dependingonthetypeof
databaseyouareusing,followtheinstructionsinoneofthefollowingsections:
ToconfigureaSQLServerdatabase,followtheinstructionsin“Creatinga
SQLServerDatabaseandDataSourceforViewComposeronpage 126.
ToconfigureanOracle9idatabase,followtheinstructionsin“Creatingan
Oracle9iDatabaseandDataSourceforViewComposeronpage 128.
ToconfigureanOracle10gdatabase,followtheinstructionsin“Configuring
anOracle10gDatabaseandDataSourceforView Composeronpage 129.
Creating a SQL Server Database and Data Source for View
Composer
ThissectiondescribeshowtoaddanewViewComposerdatabasetoanexistingSQL
Serverinstanceandmakethisdatasourcevisibletoallothercomponentsrunningon
thehostsystem.
TheseinstructionsassumethatMicrosoftSQLServer2005isinstalledonthe
VirtualCenterserverhostorinyournetwork
environment,andthatyouuseSQLServer
ManagementStudioExpresstocreateandadministerthedatasource.Ifthedatabase
residesonthesamesystemasVirtualCenterserver,youcanusetheIntegrated
WindowsAuthenticationsecuritymodel.Youcannotusethismethodofauthentication
ifthedatabaseresidesona
remotesystem.
TheinstructionsalsoassumethatyouareconfiguringthedatabaseonWindowsServer
2003SP1.SomestepsaredifferentifyouareconfiguringtheODBCdatasourceona
WindowsXPProfessionalSP2host.
SQLServerManagementStudioExpressisavailablefrom:
http://www.microsoft.com/downloadS/details.aspx?familyid=C243A5AE4BD14E3D
94B85A0F62BF7796
N
OTEIfadatabaseinstancedoesnotresideontheVirtualCenterserverhost
systemorelsewherewithinyournetworkenvironment,youmustinstallone.The
ViewComposerserviceinstallerdoesnotincludeadatabase.