Solved

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

Posted on 2016-08-24
4
43 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 40

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Teach the user how to convert virtaul disk file formats and how to rename virtual machine files on datastores. Open vSphere Web Client: Review VM disk settings: Migrate VM to new datastore with a thick provisioned (lazy zeroed) disk format: Rename a…
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four v…

821 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