Knowledge Base

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

Installing Single Sign On fails with the error: Error 29115 Cannot authenticate to DB (2035449)

Symptoms

  • Cannot install vCenter Single Sign On (SSO) on an existing database
  • Installing SSO fails
  • You see the error:

    Error 29115 Cannot authenticate to DB
  • In the Windows Event Viewer you will see the following messages:

    Login failed for user 'RSA_DBA'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 10.10.10.4]
    ERROR 858[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.error(?:?) - Failed to established connection :com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'RSA_DBA'.

Cause

The SSO installation creates the DB users RSA_USER and RSA_DBA, which requires SQL authentication to be enabled on the SQL server.

Resolution

To resolve this issue, ensure that the server authentication option is set to SQL Server and Windows Authentication mode on the SQL server.

To set the SQL Server and Windows Authentication mode:
  1. Connect to the vCenter Server database using the SQL Management Studio.
  2. Right-click the database server and click Properties.
  3. In the Security section, enable SQL Server and Windows Authentication mode. You may be prompted to restart the SQL Server service for the changes to take effect.
  4. Proceed with the SSO installation.

Additional Information

This error may also occur if the passwords include special characters, such as semicolon.

Update History

09/25/2012 - Added that this issue may also be caused by password special characters 01/15/2013 - Added additional symptoms from windows event viewer

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: