Solved

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

Posted on 2016-08-24
4
33 Views
Last Modified: 2016-09-03
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.
0
Comment
Question by:tbs_mnp
  • 2
4 Comments
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 250 total points
ID: 41770543
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
 
LVL 10

Assisted Solution

by:Richardson Porto
Richardson Porto earned 250 total points
ID: 41771115
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
 
LVL 1

Accepted Solution

by:
tbs_mnp earned 0 total points
ID: 41774606
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
 
LVL 1

Author Closing Comment

by:tbs_mnp
ID: 41782783
investigation of the root cause- we were able to solve and not have to move database.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
Teach the user how to delpoy the vCenter Server Appliance and how to configure its network settings Deploy OVF: Open VM console and configure networking:
In this video tutorial I show you the main steps to install and configure  a VMware ESXi6.0 server. The video has my comments as text on the screen and you can pause anytime when needed. Hope this will be helpful. Verify that your hardware and BIO…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now