VMware Cloud Community
fletch00
Enthusiast
Enthusiast

Upgrade to vCenter 5 "Setup failed to connect to database"

1st cut at the vCenter 5 upgrade following KB2004265 fails with:

vcenter5upgradeerror.jpg

I am upgrading a Windows 2008 SQL 2008 vCenter which I cloned from the production one and renamed for this test.

I wonder if this is confusing the upgrader since it does not even let me specify the DSN/database

Anyone seen this/offer advice?

thanks!

VCP5 VSP5 VTSP5 vExpert http://vmadmin.info
0 Kudos
6 Replies
Troy_Clavell
Immortal
Immortal

the credentials that you are logged into on the vCenter Host OS have permissions to the VCDB?  Looks to me like a permissions issue.

0 Kudos
fletch00
Enthusiast
Enthusiast

Yes I verified via 2008 studio access is fine to the vc database

Sent from my iPhone

VCP5 VSP5 VTSP5 vExpert http://vmadmin.info
0 Kudos
Troy_Clavell
Immortal
Immortal

...and you are running the installer with the same windows credentials being used to authenticate into SQL.  You have dbo on both the MSDB and VCDB?  Your DSN is being seen, I sill think it's a permissions problem.

fletch00
Enthusiast
Enthusiast

Since this is a clone I renamed I should just need to update the DSN with the new hostname?

Sent from my iPhone

VCP5 VSP5 VTSP5 vExpert http://vmadmin.info
0 Kudos
fletch00
Enthusiast
Enthusiast

Yes, once I updated the DSN was updated to the clone's new name it progressed to the next (more obvious) error Smiley Wink

1824199.png

thanks,

http://vmadmin.info

VCP5 VSP5 VTSP5 vExpert http://vmadmin.info
0 Kudos
RAMESA
VMware Employee
VMware Employee

Seems like in your inventory you have nfs datastores mounted on differenet hosts with different hostnames (may be ip address and hostname). Before trying upgrade you need to fix this; make this consistent.

Reason for not supporting this is in below example -

1. Add an NFS datastore to server1 using the array's IP (no hostname available at the time).
2. Add an NFS datastore to server2 using the array's hostname.

The UUID for the same NFS datastore is now different on both machines causing vMotion to fail.

You can look at the KB for more information -

http://kb.vmware.com/kb/1006790

Regards,

Ramesh

Regards, Ramesh
0 Kudos