I have created two servers - both running Win2003 R2 SP2 with SQL2005 SP2 running the same install of VirtualCenter 2.5 U4. Both are fully working VC server one is the live VC and other for DR. The DR server just has a blank SQL DB. The SQL DB names, SQL logins and ODBC exactly the same on both servers.
I've followed the VirtualCenter Database Miantenance doc so so far I've done an online SQL backup of the VCDB on the live server and restored overwritting the SQL DB on the DR server. Reassigned the VCenter user to the VCDB database and copied the SSL certificates across. Although i didn't need to I updated and tested the DSN which tested ok.
The problem being the Virtual Server Service fails to start everytime.
I've re-installed VC and tested DSN, VCDB SQL user access and looked for orphansed users but all looks fine. I've even copied the master db across but still unable to start the service.
The VMware VirtualCenter Server service terminated with service-specific error 2(0x2)
The virtualcenter log has the following error
To me that would be a certificate error even though i've copied this across. Am I missing something obvious????
I've tried both ways with SQL service - local system and setup local user with administrator rights. The VC service is just default local system. SQL logins are all SQL authentication.