Starting Vcenter Server Service after migrating SQL DB to another machine.

we had sql 2008 express on the physical vcenter server. the sql database maxed 10GB. we restored the backup of both databases to another machine in our environment hosting sql 2012- full version.

now I am getting in the event viewer an unknown error for the service basically saying it cant find configuration settings.

I changed the ODBC connection to point to correct server- this tested good. I also went into registry for VMware inc and changed the dbinstance to blank and the dbserver type to custom.

what do I need to do to get this working.
LVL 1
tbs_mnpAsked:
Who is Participating?
 
tbs_mnpConnect With a Mentor Author Commented:
we were able to find out there were a billion event logs in the database which stemmed from incorrect credentials on vshield..from years and years. we cleaned these up and were able to clean the DB to a reasonable size. we are all good.
0
 
lcohanConnect With a Mentor Database AnalystCommented:
What is the exact error from Vcenter Server Service? there should be a KB in vmware explaining how to deal with the SQL Server dependency.

https://kb.vmware.com/selfservice/microsites/searchEntry.do

"Cannot start the VirtualCenter Server service after migrating the vCenter Server database to a new server (1020836) "
https://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&externalId=1020836&sliceId=1&docTypeID=DT_KB_1_1&dialogID=183102607&stateId=1 0 183112376
0
 
Richardson PortoConnect With a Mentor Senior Infrastructure SpecialistCommented:
Please, attach the vpxd.log and did you upgrade the DSN to use the latest SQL Native Client ? If not, take a look here: https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1015804
0
 
tbs_mnpAuthor Commented:
investigation of the root cause- we were able to solve and not have to move database.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.