Home > VMware > VMware vCenter Server, uninstalling SQL express issues

VMware vCenter Server, uninstalling SQL express issues

I has an issue today where a customer had SQL express installed on their vCenter Server and moved their vCenter Database to another SQL Server instance on another Server.
Being thorough they also uninstalled SQL express from their vCenter Server. Unfortunately the uninstall of the SQL express also performs an uninstall of the SQL Native agent and therefore removes any ODBC DSN’s using that driver dll.
Although the SQL express uninstall was done previously, no error occurrs until the VMware vCenter Server services were restarted (or the Server was restarted).

The error was as follows and the vpxa log shows the Database cannot be located.
“Windows could not start VMware Virtual Center Service. Error code 2”

To resolve this issue re-install the SQL Native client and then recreate the ODBC DSN.

The DSN name can be found in the registry location:
HKLM\SOFTWARE\Wow6432Node\VMware, Inc\VMware VirtualCenter\DB\1
This DWORD contains the correct DSN

Create the DSN by running odbcad32 and creating a System DSN with the name from the registry setting. Then try restarting the services.

Advertisements
Categories: VMware
  1. No comments yet.
  1. February 14, 2011 at 10:05 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: