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

  • You 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 vm-sso-javaLib.log (located at %TEMP%), you see entries similar to:

    [YYYY-MM-DD] INFO 16[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - DB information jdbcUrl:jdbc:sqlserver://;serverName=a629uk120.crowncork.com;port=1433;databaseName=RSA type: Mssql userName:RSA_DBA
    [YYYY-MM-DD]ERROR 577[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.error(?:?) - Failed to established connection :com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'RSA_DBA'.
    [YYYY-MM-DD] INFO 577[main] - com.vmware.vim.installer.core.logging.CoreLoggerImpl.info(?:?) - could not close JDBC connection


  • In the Windows Event Viewer, you see messages similar to:

    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'.

  • In SQL Server logs, you see the entry:

    Error: 18456, Severity: 14, State: 12. Login-based server access validation failed with an infrastructure error. Check for previous errors" in relation to the RSA_DBA account or the RSA_USER account.

Cause

The SSO installation creates the database 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.

See Also

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

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