Installation guide

ESX Server 3 Installation Guide
68 VMware, Inc.
4UsetheNet8ConfigurationAssistanttoaddthefollowingentry:
VPX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=vpxd-Oracle)(PORT=1521))
)
(CONNECT_DATA =
(SERVICE_NAME = VPX)
)
)
HOST =
Inthisexample,HOSTisthemanagedhosttowhichtheclientneedstoconnect.
Configuring a SQL Server ODBC Connection
WhenyouinstalltheVirtualCenter Server,youcanestablishaconnectionwithaSQL
Serverdatabase.ThefollowingproceduredescribeshowtoconfigureaSQLServer
ODBCconnection.
SeeyourMicrosoftSQLODBCdocumentationforspecificinstructionsregarding
configuringtheSQLServerODBCconnection.
IfyouuseSQLServerforVirtualCenter,do
notusethemasterdatabase.
Beforeyoubeginthisprocedure,reviewtherequireddatabasepatchesspecifiedin
Table 2‐1,“SupportedDatabaseFormats (S EE U PDATE ) ,”onpage 19.Ifyoudonot
prepareyourdatabasecorrectly,theVirtualCenterinstallermightdisplayerrorand
warningmessages.
To prepare a SQL Server database to work with VirtualCenter
1OnyourMicrosoftSQLServer,createaSQLServerdatabaseusingEnterprise
ManagerontheSQLServer.
2OnyourMicrosoftSQLServer,createaSQLServerdatabaseuserwithdatabase
operator
(DBO)rights.
ThedefaultdatabasefortheDBOuseriswhatyoudefinedinStep 1.
Makesurethedatabaseuserhaseitherasysadminserverroleorthe
db_owner fixeddatabaseroleontheVirtualCenterdatabaseandtheMSDB
database.
(S EE U PDATE )
NOTEMicrosoftWindowsNTauthenticationisnotsupportedwithremoteSQL
Server.