Knowledge Base

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

Starting VMware VirtualCenter Server service when using SQL authentication fails with the error: Login Failure, Failed to connect to database (2015824)

Symptoms

  • Cannot start the VMware VirtualCenter Server service when using Microsoft SQL authentication
  • VMware VirtualCenter Server service fails to start
  • In the vpxd log, located at C:\ProgramData\VMware\VMware Virtual Center\Logs, you see entries similar to:

    2012-03-16T10:54:43.364-04:00 [03404 error 'Default'] [VpxdVdb::SetDBType]: Login failure - retrying once...
    2012-03-16T10:54:43.364-04:00 [03404 error 'Default'] [VpxdVdb::SetDBType] Failed to connect to database: . Retry attempt: 1 ...
    2012-03-16T10:54:53.364-04:00 [03404 error 'Default'] [VpxdVdb::SetDBType] Encountered login error. Subsequent connection attempt failed: 28000
    2012-03-16T10:54:53.364-04:00 [03404 error 'Default'] [VpxdVdb::SetDBType] Aborting after 1 retries.
    2012-03-16T10:54:53.364-04:00 [03404 error 'Default'] Error getting configuration info from the database
    02-05T11:12:25.712+08:00 [02364 error 'Default'] [VpxdVdb::SetDBType] Failed to connect to database: ODBC error: (08001) - [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [64]. . Retry attempt: 49 ..."
  • In the Windows Event Viewer, the VMware VirtualCenter Server service reports an error similar to:

    The description for Event ID 1000 from source VMware VirtualCenter Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

Cause

This issue occurs if:

  • The VMware VirtualCenter Server service is unable to communicate with the remote database
  • There are authentication issues with the remote Microsoft SQL database when using SQL authentication

Resolution

To resolve this issue, ensure to:

Verify the DSN

Ensure that the VMware VirtualCenter Server service can communicate with the remote Microsoft SQL server.
  1. In the Control Panel, navigate to Administrative Tools > Data Sources (ODBC) > System DSN.
  2. Select the vCenter Server DSN and click Configure.
  3. Verify the remote SQL server name, username, and default database.
  4. Test the connection to the SQL server.
  5. If it fails to connect, investigate the SQL user account used for this connection on the database server.

Verify Log on As in Windows for VMware VirtualCenter Server service

Ensure that the VMware VirtualCenter Server service is running as Local System.
  1. Click Start > Run, type services.msc, and click OK. The Services Management Snap-in opens.
  2. Right-click VMware VirtualCenter Server service and click Properties.
  3. Click the Log On tab.
  4. Verify and ensure that the Local System account option is selected.

Verify the database username in the registry

In some cases, the username for the database must be manually entered.

Note: This procedure modifies the Windows registry. Before making any registry modifications, ensure that you have a current and valid backup of the registry and the virtual machine. For more information on backing up and restoring the registry, see the Microsoft Knowledge Base article 136393.

The preceding link was correct as of March 13th 2013. If you find the link is broken, provide feedback and a VMware employee will update the link.
 
To manually enter the username for the database:
  1. Take a backup of the Windows registry before proceeding.
  2. Click Start > Run, type regedit, and click OK. The Registry Editor window opens.
  3. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\VMware, Inc.\VMware Virtualcenter\DB.
  4. Edit Key 2 and enter the username in the value data field.

Reset the encrypted password found in the registry

Verify that the VMware VirtualCenter Server service can authenticate to the remote Microsoft SQL server.

  1. Open a command prompt as an administrator.
  2. Change to the vCenter Server directory using this command:

    cd "C:\Program Files\VMware\Infrastructure\VirtualCenter Server"

    Where C:\ is the drive where vCenter Server is installed.

  3. Run this command:

    vpxd.exe -p

  4. Enter the same password that you used while verifying the DSN connection.
  5. Start the VMware VirtualCenter Server service.

Additional Information

For more information, see the Microsoft Technet article Backing Up and Restoring the Registry.

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

Update History

03/14/2013 - Added note to back up the registry 05/13/2013 - Added vCenter Server 5.1.x to Products

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

  • 11 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)
  • 11 Ratings
Actions
KB: