VMware ESX Manual

A SERVICE OF

next previous

ESX Server 3 and VirtualCenter Installation Guide

70 VMware, Inc.

7TocreateanewSQLServerODBCconnection:

aClickAdd.

bForSQLServer2000,selectSQLServerandclickFinish.

ForSQLServer2005,selectSQLNativeClientandclickFinish.

8TypeanODBCdatastorename(DSN)nameintheNamefield.

For example,typeVMware VirtualCenter.

9 (Optional)TypeanODBCDSN

descriptionintheDescriptionfield.

10 SelecttheservernamefromtheServerdrop‐downmenu.

TypetheSQLServermachinenameinthetextfieldifyoucannotfinditinthe

drop‐downmenu.

11 ClickNext.

12 Selectoneoftheauthenticationmethods:

 IfyouareusinglocalSQLSe rver,selectWindowsNTauthentication.Itisal so

knownas“trustedauthentication”andissupportedonlyiftheSQLServeris

runningonthesamesystemastheVirtualCenter Server .

 IfyouareusingremoteSQLServer,selectSQLServerauthentication.

WindowsNTauthenticationisnotsupportedonremoteSQLservers.

13 TypeyourSQLServerloginnameandpasswordandclickNext.

Askyourdatabaseadministratorforthisinformation.

14 SelectthedatabasecreatedforVirtualCenterfromtheChangethedefault

database

tomenuandclickNext.

15 ClickFinish.

16 FromtheODBCMicrosoftSQLServerSetupmenu,chooseTestDataSource.

Ifthetestdatasourceisacceptable,clickOK.Ifitisnotacceptable,returnand

reconfigureanyincorrectitems.

ToclosetheODBCDataSourceAdministrator,clickClose.

17 Ensurethat

theSQLAgentisrunningonyourdatabaseserver.

ThisappliestoSQLServer2000andSQLServer2005editions.