Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

VMware VirtualCenter Server service does not start automatically after reboot (1007669)

Symptoms

  • VirtualCenter Server service does not start after reboot
  • VMware Infrastructure (VI) Client cannot connect to VirtualCenter
  • You are using Microsoft SQL Server or SQL Express
  • VirtualCenter Server service can be started manually with no problems
  • The below error may be reported in the vpxd.log :

    ODBC error: (08001) - [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].



Purpose

In some cases, a race condition can occur when the VirtualCenter Server service starts before the SQL database service it depends on is started.
 
This article provides steps to prevent the race condition from occurring.

Resolution

This issue may occur if the VirtualCenter Server service starts before one of the services it depends on is started. The VirtualCenter Server service is dependent on the following services:
  • SQL Services
  • ADAM Services (when using linked mode in vCenter Server 4.x)
To resolve this issue, add a dependency to the VirtualCenter service so that it starts only after the necessary services have started.

Note: This solution assumes that the database server and the SQL server reside on the same machine. If the SQL server is on a different physical machine, you must ensure that the SQL server is functioning before attempting to start the VirtualCenter service. 
In addition this same procedure can be used on any service that experiences this issue such as vCenter Server Webservices.
 
Caution: This article contains information about modifying the Windows registry. Before you modify the registry, make a backup copy of it and be sure that you understand how to restore the registry if a problem occurs. Instructions for making backups of the registry and restoring the registry are available on the Microsoft Web site at http://support.microsoft.com/default.aspx?scid=kb;en-us;136393.
 
To create a service dependency:
  1. Click Start > Run.
  2. Type services.msc and press Enter.
  3. Locate any services that vCenter Server requires. For example, SQLEXP_VIM, ADAM_VCMSDS, or ADAM_VMwareVCMSDS.

    Note: Service names are different in SQL Express and full SQL implementations. For example, the service name in SQL Express is SQLEXP_VIM and in full SQL implementations, it is MSSQLSERVER.

  4. Open the service properties and note the service name. For example, MSSQL$SQLEXP_VIM .
  5. Click Start > Run, type regedit, and click OK. The Registry Editor window opens.
  6. Browse to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\vpxd.
  7. Double-click the DependOnService key and add the Service name using the name identified in Step 4.
  8. Close the Registry Editor window.
  9. In the Services window, open the service properties for the service identified in Step 3.
  10. In the Dependencies tab, verify the VMware VirtualCenter service is listed as depending on the service.
  11. Repeat Steps 3 to 9 for any services that VirtualCenter requires.
If you are running Windows 2008 you can set the VMware VirtualCenter Server service to startup type Automatic (Delay) as follows:
  1. Click Start > Run, type services.msc, and click OK.
  2. Right-click on the VMware VirtualCenter Server service and click Properties.
  3. Change the startup type from Automatic to Automatic (Delay).
Notes:
  • For more information on the DependOnService key, see the Microsoft article 193888.

    The preceding link was correct as of April 25, 2011. If you find the link is broken, provide feedback and a VMware employee will update the link.

  • If the VMware SSL Certificate Automation Tool is being used, changing the service dependencies may impact the tool.  The VMware SSL Certificate Automation Tool needs to be able to start and stop specific services.

  • Check and modify the startup type every time after a vCenter Server upgrade is carried out, as the startup may get reset to the default startup type of Automatic.

Additional Information

There are differences in the way SQL 2005 and SQL 2008 handle the startup and the database readiness. SQL 2005 gives the database access immediately after the start up free for access (the method is FastRecovery), whereas SQL 2008 refuses to take connections until it finished with the Checking the databases, which can take up to 1 Minute.
 
For more information about Recovery Performance in SQL Server, see the Microsoft article http://msdn.microsoft.com/en-us/library/ms189262%28SQL.100%29.aspx.

Note: The preceding link was correct as of April 25, 2011. If you find the link is broken, provide feedback and a VMware employee will update the link.

Tags

virtualcenter-web-service  virtualcenter-server-service

See Also

This Article Replaces

2008787

Update History

09/06/2011 - Added caution on modifying registry 11/11/2011 - Added ADAM_VMwareVCMSDS to the list of services in Step 3 05/23/2013 - Added note to solution.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 89 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 89 Ratings
Actions
KB: