VMware Cloud Community
toha
Enthusiast
Enthusiast

moving virtualcenter 2.5 database from mssql 2000 SP4 -> 2005 SP2

Hi,

We tried to move vc database from old sql server to a new one (as subject says), but after moving database, created a new odbc connection virtualcenter process won't start and

event log says: The VMware VirtualCenter Server service terminated with service-specific error 2 (0x2).

Any ideas how to debug / solve this?

Thanks.

Reply
0 Kudos
5 Replies
philvirt
Hot Shot
Hot Shot

Verify permissions of your user on the SQL database. You might have to assign it SA - System Administrator privileges.

Regards,

Fil

Thanks, phIL
Reply
0 Kudos
kinsden
Enthusiast
Enthusiast

The database user needs to have dbo rights on VC database as well as MSDB.

Reply
0 Kudos
kjb007
Immortal
Immortal

Open a dos prompt on the virtual center server, cd into the install folder, and run virtual center in console mode 'vpxd -s'

This should give you additional debug output. Post the output.

-KjB

vExpert/VCP/VCAP vmwise.com / @vmwise -KjB
Reply
0 Kudos
RParker
Immortal
Immortal

You can't simply move it, you have to upgrade it via the VC upgrade.

2000 and 2005 are different and you can't move the data, you have to perform a database upgrade.

Reply
0 Kudos
kinsden
Enthusiast
Enthusiast

How do you mean : 'you have to upgrade it via the VC upgrade' ... I think VC 2.5 is the latest version, isn't it?

Reply
0 Kudos