Could anybody please assist on the below details.
On saturday, we tried migrating vCenter server DB from SQL server 2005full edition to SQL server 2014 full edition and performed following tasks has been performed as per the below link,
Windows could not start the VMware VirtualCenter Server on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2.
Much appreciate if anyone kindly assist me on this
Have you updated the SQL client to the latest version ? And which account you're using in vCenter Server services ? Can you share the vpxd.log ?
Thanks for the reply.
Yes I have updated to SQL Server Native Client 11.0 or is there any other ODBC driver there for SQL server 2014, please advise
We are using local system account in the vCenter server services.
Regarding the vpxd.log, we have reverted to the current snapshot so cannot get the vpxd.log after the migration
Kindly help to advise me on this
Thanks for your reply.
Yes have verified the port 1433 open on the new SQL 2014 DB server and did check the SQL services was started and running.
Is there any other thing that we need to check, pleae advise.
So, you did a rollback and now are running the old SQL version, right ? If yes, next time after the DSN changes, try update the database password in registry just launching a elevated command prompt and running "vpxd -p".
Yes we did a rollback and now we are running on the old SQL version now
So you mean to say that the DB password update would have caused not to start the vCenter services after the migration.
Moreover I am able to edit the following key settings.
HKEY_LOCAL_MACHINE\SOFTWARE\VMware, Inc.\VMware Virtualcenter\DB.
Edit Key 2 and enter the username in the value data field
Please help to advise.