Solved

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

Posted on 2016-08-24
4
51 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

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.
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
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…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

630 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