ESX Server 3 Installation Guide
68 VMware, Inc.
4UsetheNet8ConfigurationAssistanttoaddthefollowingentry:
VPX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=vpxd-Oracle)(PORT=1521))
)
(CONNECT_DATA =
(SERVICE_NAME = VPX)
)
)
HOST =
Inthisexample,HOSTisthemanagedhosttowhichtheclientneedstoconnect.
Configuring a SQL Server ODBC Connection
WhenyouinstalltheVirtualCenter Server ,youcanestablishaconnectionwithaSQL
Serverdatabase.ThefollowingproceduredescribeshowtoconfigureaSQLServer
ODBCconnection.
SeeyourMicrosoftSQLODBCdocumentationforspecificinstructionsregarding
configuringtheSQLServerODBCconnection.
IfyouuseSQLServerforVirtualCenter,do
notusethemasterdatabase.
Beforeyoubeginthisprocedure,reviewtherequireddatabasepatchesspecifiedin
Table 2‐1,“SupportedDatabaseFormats,”onpage 19.Ifyoudonotprepareyour
databasecorrectly,theVirtualCenterinstallermightdisplayerrorandwarning
messages.
To prepare a SQL Server database to work with VirtualCenter
1OnyourMicrosoftSQLServer,createaSQLServerdatabase
usingEnterprise
ManagerontheSQLServer.
2OnyourMicrosoftSQLServer,createaSQLServerdatabaseuserwithdatabase
operator(DBO)rights.
ThedefaultdatabasefortheDBOuseriswhatyoudefinedinStep 1.
Makesurethedatabaseuserhaseitherasysadminserverroleorthedb_owner
fixed
databaseroleontheVirtualCenterdatabaseandtheMSDBdatabase.
(S
EE
U
PDATE
)
NOTEMicrosoftWindowsNTauthenticationisnotsupportedwithremoteSQL
Server.
