Installing Single Sign-On fails with the error: Error 29115 Cannot authenticate to DB
search cancel

Installing Single Sign-On fails with the error: Error 29115 Cannot authenticate to DB

book

Article ID: 321047

calendar_today

Updated On:

Products

VMware vCenter Server

Issue/Introduction

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=example.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.


Environment

VMware vCenter Server 5.1.x

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.