3.0.1

Table Of Contents
VMware, Inc. 105
Chapter 6 View Composer
TheseinstructionsassumethatMicrosoftSQLServer2005isinstalledlocallyonthe
VirtualCenterhost,andthatSQLServerManagementStudioExpresswillbeusedto
createandadministerthedatasource.Ifthedatabaseresidesonthesamesystemas
VirtualCenteryoucanusetheIntegratedWindowsAuthenticationsecuritymodel;you
cann
otusethismethodofauthenticationifthedatabaseresidesonaremotesystem.
SQLServerManagementStudioExpressisavailablefrom:
http://www.microsoft.com/downloadS/details.aspx?familyid=C243A5AE4BD14E3D
94B85A0F62BF7796
Add a linked clone desktop database instance to SQL Server 2005
1OntheVirtualCenterserverhostsystemselectStart>AllPrograms>Microsoft
SQLServer2005>SQLServerManagementStudioExpressandconnecttothe
exi
stingSQLServerinstanceforVirtualInfrastructureManagement.
2IntheObjectExplorerpane,rightclicktheDatabasesentryandselectNew
Database...YouarepresentedwiththeNewDatabasedialog.
3Enteraname(forexamplelinkedClone)intheDatabasenamefieldandclick
OK.Yourdatabaseisaddedun
dertheDatabasesentryintheObjectExplorer.
4ExitMicrosoftSQLServerManagementStudioExpress.
Add an ODBC datasource
1 SelectStart>AdministrativeTools>DataSource(ODBC).TheMicrosoftODBC
DataSourceAdministratorwizardisdisplayed.
2 SelecttheSystemDSNtab.
3ClickAddandselectSQLNativeClientfromthelist.TheCreateaNewDat
a
SourcetoSQLsetupwizardisdisplayed.
4Intheappropriatefields,enteraname(forexample,VMware Linked Clone)and
abriefdescriptionofthelinkedclonedesktopdatabase.
5IntheServerfield,entertheserverdetailsintheform<hostname>\<database
name>,where<hostname>isthenameofthehostsystemand<databa
se>isthe
SQLServerinstance.Forexample:
VCHOST1\SQLEXP_VIM
ClickNext.
N
OTEIfaSQLserverdoesnotresideontheVirtualCenterhostsystemorelsewhere
withinyourenvironmentyoumustinstalloneastheViewComposerserviceinstaller
doesnotincludeadatabase.