VMware Cloud Community
Dreher
Enthusiast
Enthusiast

Migrate Database vCenter to other server !!!

Friends, I migrated the sqlexpress database to a new sql server server, vCenter changed the odbc to the new server and database via ODBC connection works 100%, but when I restart the vCenter service is still used to base of ancient sqlexpress data, realized the vCenter service there is a dependence that points to the served the sqlexpress / instantiates, how can I change this dependence to point to the new server?

Reply
0 Kudos
2 Replies
MattiasN81
Hot Shot
Hot Shot

There are a number of services that uses the vCenter DB, such as SSO, Tomcat (Webservices)

The absolute easiest way to move a vCenter DB is to run the vCenter installation and point to the new DB during installation, that way all vCenter components gets updated.

if u dont want to rerun the installation u can follow the VMware KB: 1028601

VMware Certified Professional 6 - DCV VMware VTSP Software Defined Storage Dell Blade Server Solutions - EMEA Certified Dell PowerEdge Server Solutions - EMEA Certfied Dell Certified Storage Deployment Professional Dell EMC Proven Professional If you found my answers useful please consider marking them as Helpful or Correct
Reply
0 Kudos
rcporto
Leadership
Leadership

To change vCenter service dependency, open the DependOnService key on regedit located on HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\vpxd.

Take a look here for more details about change vCenter dependencies: VMware KB: VMware VirtualCenter Server service does not start automatically after reboot

---

Richardson Porto
Senior Infrastructure Specialist
LinkedIn: http://linkedin.com/in/richardsonporto
Reply
0 Kudos