VMware Cloud Community
branfarm1
Contributor
Contributor

Unable to install VirtualCenter server

Hi,

My old virtual Center server running Win2003 and VC 2.5 "unexpectedly" died this week. Fortunately I had the VC database hosted externally, so all the information is still around, I just need to install VC again.

I'm trying to install it on a new Win2008 R2 x64 box. I used the .msi/ORCA workaround to enable me to start the install on a 64-bit box, but when I get to the "Database Information" portion of the setup I receive:

"Setup failed to connect to the database pointed to by the given DSN. Please make sure that you have the proper permissions to access your database."

I created the DSN using the SQL Native Client, and I'm using the same db user as was previously configured. I've searched the web and found a lot of people who fixed their issue by adding dbo privileges to the MSDB database for the VirtualCenter database user, but this has not worked for me.

Can anyone help?

Thanks in advance,

Brandon

Reply
0 Kudos
5 Replies
branfarm1
Contributor
Contributor

I found the log for the installer and here are the messages I'm receiving:

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Begin Logging

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 --- CA exec: VMCheckDsn

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Getting Property DB_DSN = vmware

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Getting Property DB_USERNAME = vmware

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Successfully connected to the custom database

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Database Name is Microsoft SQL Server

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Database Version is 10.00.1600

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Client Driver is SQL Native Client

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Driver Version is 09.00.3042

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Database Server Name is SQLSRV

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Setting property SQL_DB_TYPE = SQL Native Client

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 sql query: SELECT serverproperty('Edition')

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 sql server edition installed is <Enterprise Edition (64-bit)>

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 SQL Server is not a desktop edition.

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 SQLFetch: DB Name = VirtualCenter

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 The DSN is NOT pointing to the master database.

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Query :SELECT * FROM vmware.VPX_VERSION;

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 The database name is VirtualCenter

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Normalized user name is :vmware

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Error returned while checking the Virtual Center database for jobs. This could be because the installer could not connect to the database pointed to by the DSN, or due to insufficient privileges to query the database.

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Getting Property UILevel = 5

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Attempting to retrieve error message for error Id: 25056

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Msi Error table Query is <SELECT Message FROM Error WHERE Error=25056>

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Error message is Setup failed to connect to the database pointed to by the given DSN. Please make sure that you have the proper permissions to access your database.

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Successfully retrieved error message from Error table

VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Getting Property ProductName = VMware VirtualCenter Server

VMware VirtualCenter-build-227637: 02/12/10 10:04:42 Setting property DatabaseOK =

VMware VirtualCenter-build-227637: 02/12/10 10:04:42 Setting property FORMAT_DB =

VMware VirtualCenter-build-227637: 02/12/10 10:04:42 Setting property LAUNCHWIZARD =

VMware VirtualCenter-build-227637: 02/12/10 10:04:42 Setting property VPX_START = 1

VMware VirtualCenter-build-227637: 02/12/10 10:04:42 End Logging

Reply
0 Kudos
Troy_Clavell
Immortal
Immortal

>VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Error returned while checking the Virtual Center database for jobs. This could be because the installer could not connect to the database pointed to by the DSN, or due to insufficient privileges to query the database.

Do you have dbo on both the MSDB and the VCDB?

Reply
0 Kudos
branfarm1
Contributor
Contributor

Yes -- I've verified these permissions on both the msdb and virtualcenter databases.

Reply
0 Kudos
Troy_Clavell
Immortal
Immortal

...and your ODBC system DSN is pointed to the correct DB instance?

>VMware VirtualCenter-build-227637: 02/12/10 10:04:40 Error message is Setup failed to connect to the database pointed to by the given DSN. Please make sure that you have the proper permissions to access your database.

to me it seems to be a permissions issue, or your ODBC information is wrong.

Reply
0 Kudos
Troy_Clavell
Immortal
Immortal

couple other things..

http://kb.vmware.com/kb/1010401

also, W2K8 R2 x64 is not a supported host OS for vCenter

http://www.vmware.com/pdf/vsphere4/r40/vsp_compatibility_matrix.pdf

Reply
0 Kudos