8 Replies Latest reply on Feb 19, 2015 4:27 AM by IDIER NICOLAS

    BSA 8.6.00 Problem during installation

    IDIER NICOLAS

      I try to install BSA 8.06.00 on an windows 2012 server with Sql Server 2014.

      I follow your documentation but i'm stuck when i type the SQL Server database information in the BSA Installer.

       

      So in the database information form, i enter the Hostname, the Port (already configured in Database instance and firewall), the database name (bladelogic with the rights discribed in your online documentation), the password and then I click NEXT

       

      Then, I've seen that the installer do something but it crash a nasty message 'Database Validation Error'

       

      with the message :

      Database connection attempt failed.

      Login failed for user 'bladelogic'.

       

      I verify the login and password  and i don't know from where the problem is.

       

      I need your help, BSA Guru

        • 1. Re: BSA 8.6.00 Problem during installation
          Sean Berry

          Does the password have special characters, especially exclamation point or dollar sign?

           

          --

          Sean Berry

          sberry@bmc.com<mailto:sberry@bmc.com>

          414-339-1033

          • 2. Re: BSA 8.6.00 Problem during installation

            What does the installer logs says?

            • 3. Re: BSA 8.6.00 Problem during installation
              IDIER NICOLAS

              Hi Sean,

              the password is a 2 char password very simple.

              I post to Pankaj the log of installation

              • 4. Re: BSA 8.6.00 Problem during installation
                IDIER NICOLAS

                Hi Pankaj,

                here is below the log when i try to continue BSA installation :

                tell me if you find something or if you got some ideas.

                 

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[NEXT SELECTED]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY INSTALL_AND_USE_ORACLEXE_DATABASE],Detail=[false]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY USE_ADVANCE_DATABASE_CONNECTION_STRING],Detail=[false]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY SCHEMA_HOST],Detail=[TCSGAWIN10]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY SCHEMA_PORT],Detail=[1433]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY SCHEMA_INSTANCE],Detail=[bladelogic]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY SCHEMA_LOGIN],Detail=[bladelogic]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY SCHEMA_PASSWORD],Detail=[DES\:5842b4f4b1801e3a08839e457d4e2050]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY CONFIRM_SCHEMA_PASSWORD],Detail=[DES\:5842b4f4b1801e3a08839e457d4e2050]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY BLADELOGIC_TABLESPACE_NAME],Detail=[BLADELOGIC]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY BLADELOGIC_INDEX_TABLESPACE_NAME],Detail=[BLADELOGIC_INDEX]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=[VALIDATION_SUCCESS]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY VALIDATION_WARNING_RESULT],Detail=[VALIDATION_SUCCESS]}

                (Feb 19 2015 09:53:57.422 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[CREATED InstallationTask],Detail=[com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask]}

                (Feb 19 2015 09:53:57.500 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[STARTED InstallationTask],Detail=[com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask]}

                (Feb 19 2015 09:53:57.500 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[MESSAGE BUNDLE],Detail=[product.bsaoneclickinstall.BSAOneClickInstallProgressMessages]}

                (Feb 19 2015 09:53:57.500 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[VALIDATION DISPLAY MESSAGE BUNDLE],Detail=[product.bsaoneclickinstall.BSAOneClickInstallInstallerMessages]}

                (Feb 19 2015 09:53:57.500 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[VALIDATION FEATURE],Detail=[featureBSAOneClickInstall]}

                (Feb 19 2015 09:53:57.500 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY VALIDATION_FEATURE],Detail=[featureBSAOneClickInstall]}

                (Feb 19 2015 09:53:57.612 AM +0100),INFO,com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask,

                  PROGRESS EVENT {Description=[databaseInformationValidation.description],Progress=[0],Detail=[databaseInformationValidation.validateSchemaHost]}

                (Feb 19 2015 09:53:57.703 AM +0100),INFO,com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask,

                  PROGRESS EVENT {Description=[databaseInformationValidation.description],Progress=[10],Detail=[databaseInformationValidation.validateSchemaPort]}

                (Feb 19 2015 09:53:57.812 AM +0100),INFO,com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask,

                  PROGRESS EVENT {Description=[databaseInformationValidation.description],Progress=[20],Detail=[databaseInformationValidation.validateSchemaInstance]}

                (Feb 19 2015 09:53:57.922 AM +0100),INFO,com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask,

                  PROGRESS EVENT {Description=[databaseInformationValidation.description],Progress=[30],Detail=[databaseInformationValidation.validateSchemaLogin]}

                (Feb 19 2015 09:53:58.015 AM +0100),INFO,com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask,

                  PROGRESS EVENT {Description=[databaseInformationValidation.description],Progress=[40],Detail=[databaseInformationValidation.validateSchemaPassword]}

                (Feb 19 2015 09:53:58.140 AM +0100),INFO,com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask,

                  PROGRESS EVENT {Description=[databaseInformationValidation.description],Progress=[50],Detail=[databaseInformationValidation.validateConfirmSchemaPassword]}

                (Feb 19 2015 09:53:58.249 AM +0100),INFO,com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask,

                  PROGRESS EVENT {Description=[databaseInformationValidation.description],Progress=[70],Detail=[databaseInformationValidation.validateDBConnection]}

                (Feb 19 2015 09:53:58.249 AM +0100),INFO,com.bmc.install.product.bladelogic.utils.BladelogicInstallPreChecks,

                  LOG EVENT {Description=[Performing SQL Server DB pre-checks for object],Detail=[BladelogicDBDetails [dbServer=TCSGAWIN10, port=1433, schemaInstance=bladelogic, user=bladelogic, password=********, dbType=SQL_SERVER, isSysDBA=true, type=DB, isSelected=true, tableSpace=null, tableSpaceIndex=null, installDir=null, isLocal=false, sysUser=null, sysPassword=null, tableSpacePath=null, tableSpaceIndexPath=null, isNCHAR=false]]}

                (Feb 19 2015 09:53:58.280 AM +0100),SEVERE,com.bmc.install.product.bladelogic.utils.BladelogicInstallPreChecks,

                  THROWABLE EVENT {Description=[Bladelogic DB component pre-check failed.]},

                  Throwable=[com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'bladelogic'. ClientConnectionId:068d1543-a497-44a6-a75f-d0d707f8a6c0

                  com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)

                  com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)

                  com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)

                  com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)

                  com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)

                  com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)

                  com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)

                  com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

                  com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)

                  com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)

                  com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)

                  com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)

                  com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)

                  java.sql.DriverManager.getConnection(Unknown Source)

                  java.sql.DriverManager.getConnection(Unknown Source)

                  com.bmc.install.product.bladelogic.utils.BladelogicInstallPreChecks.getConnection(BladelogicInstallPreChecks.java:74)

                  com.bmc.install.product.bladelogic.utils.BladelogicInstallPreChecks.performDBValidation(BladelogicInstallPreChecks.java:37)

                  com.bmc.install.product.bladelogic.fresh.BladelogicFreshInstallManager.performDBValidations(BladelogicFreshInstallManager.java:664)

                  com.bmc.install.product.bladelogic.manager.BladelogicInstallManager.performDBValidations(BladelogicInstallManager.java:70)

                  com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask.performDBValidations(BSAOneClickInstallDatabaseInformationValidationTask.java:362)

                  com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask.performValidation(BSAOneClickInstallDatabaseInformationValidationTask.java:188)

                  com.bmc.install.task.ValidationTask.execute(ValidationTask.java:54)

                  com.bmc.install.task.InstallationTask.run(InstallationTask.java:93)

                  java.lang.Thread.run(Unknown Source)]

                (Feb 19 2015 09:53:58.389 AM +0100),INFO,com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask,

                  PROGRESS EVENT {Description=[databaseInformationValidation.description],Progress=[100],Detail=[databaseInformationValidation.complete]}

                (Feb 19 2015 09:53:58.389 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=[Database connection attempt failed.<blockquote>Login failed for user 'bladelogic'. </blockquote>]}

                (Feb 19 2015 09:53:58.389 AM +0100),INFO,com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask,

                  LOG EVENT {Description=[Validation error],Detail=[Database connection attempt failed.<blockquote>Login failed for user 'bladelogic'. </blockquote>]}

                (Feb 19 2015 09:53:58.516 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[COMPLETED InstallationTask],Detail=[com.bmc.install.product.bladelogic.BSAOneClickInstallDatabaseInformationValidationTask]}

                (Feb 19 2015 09:53:58.516 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[DISPLAYED InstallationPanelDelegate],Detail=[com.bmc.install.product.bladelogic.ui.BSAOneClickInstallationDatabaseInformationValidationPanelDelegate]}

                (Feb 19 2015 09:53:58.516 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[MESSAGE BUNDLE],Detail=[product.bsaoneclickinstall.BSAOneClickInstallInstallerMessages]}

                (Feb 19 2015 09:53:58.516 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[VALIDATION FEATURE],Detail=[featureBSAOneClickInstall]}

                (Feb 19 2015 09:54:00.183 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[PREVIOUS SELECTED]}

                (Feb 19 2015 09:54:00.183 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=[VALIDATION_SUCCESS]}

                (Feb 19 2015 09:54:00.183 AM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,

                  LOG EVENT {Description=[SET PROPERTY VALIDATION_FEATURE],Detail=[]}

                (Feb 19 2015 09:54:00.199 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[DISPLAYED InstallationPanelDelegate],Detail=[com.bmc.install.product.bladelogic.ui.BSAOneClickInstallationDatabaseInformationPanelDelegate]}

                (Feb 19 2015 09:54:00.199 AM +0100),CONFIG,com.bmc.install.product.base.project.runner.ProjectRunner,

                  LOG EVENT {Description=[MESSAGE BUNDLE],Detail=[product.bsaoneclickinstall.BSAOneClickInstallInstallerMessages]}

                • 5. Re: BSA 8.6.00 Problem during installation
                  Rahul Boraste

                  Hi,

                   

                  Check with Database Name & User name whether you have entered correct values.

                   

                  OR

                   

                  Check with database Script version, script version should match with App server version .

                   

                  Regards,

                  Rahul

                  • 6. Re: BSA 8.6.00 Problem during installation
                    Rahul Boraste

                    Your Logs Says that :

                     

                     

                     

                    THROWABLE EVENT {Description=[Bladelogic DB component pre-check failed.]},

                     

                      Throwable=[com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'bladelogic'. ClientConnectionId:068d1543-a497-44a6-a75f-d0d707f8a6c0

                    • 7. Re: BSA 8.6.00 Problem during installation
                      Aryan Anantwar

                      Hi,

                       

                      is bladelogic user exists in DB?

                      have tried login to SQL DB using the same username & password (bladelogic/**)?

                       

                      Regards,

                      Aryan Anantwar

                      • 8. Re: BSA 8.6.00 Problem during installation
                        IDIER NICOLAS

                        I fund my problem with your help !

                        in fact the default configuration in MS SQL EXpress 14 is to only have Windows Authen Mode connexion available.

                        You need to configure MS SQL to authorize SQL Server and Window Authentification mode.

                         

                        Then It works.... right now the installation is running