VMware Cloud Community
keberso
Contributor
Contributor

vCenter Install

I am installing vCenter and SQL Standrd 2005 on the same server. Following the installation of SQL and the creation of account and database, is there still a requirment for the SQL ODBC connection to be configured? Also, how to you determine the ODBC data store name?

Thanks!

Reply
0 Kudos
2 Replies
AndreTheGiant
Immortal
Immortal

Following the installation of SQL and the creation of account and database, is there still a requirment for the SQL ODBC connection to be configured?

Yes

Also, how to you determine the ODBC data store name?

You have to specify the DB hostname, and the DB name

Andre

**if you found this or any other answer useful please consider allocating points for helpful or correct answers

Andrew | http://about.me/amauro | http://vinfrastructure.it/ | @Andrea_Mauro
Reply
0 Kudos
admin
Immortal
Immortal

Here is the procedure for creating DSN

Open the ODBC datasource Administrator wizard

Click on the "System DSN" tab and click new

Select "SQL Native Client" if you are using MSSQL 2005 database and click OK.

Enter a Name for the DSN. THIS NAME SHOULD BE SPECIFIED DURING VCENTER INSTALLATION.

Enter sql server name in Server field and click next

If you are planning to use SQL Server authentication select the second option and enter username and password. Else select the default option.

Select the VC Database from the list and finish the operation.

Now run the installer and use the above created DSN during installation Smiley Happy

-Sandeep

Reply
0 Kudos