Remedy - AR System Server - Installer fails on MSSQL with Windows Authentication mode: "[Failed to validate AR DB user sessions],Detail=....User does not have permission to perform this action.]"

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    AR System Server


    APPLIES TO:

    Remedy AR System Server installation v9.1.x, v18.05 and higher.



    PROBLEM:

    The installation Remedy AR System Server (v9.1.x, v18.05 or higher) with MSSQL database and using Windows Authentication mode, it fails showing in the installation log the following message:
    ........................
    (Aug 13 2018 05:13:51.406 PM +0100),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDatabaseInformationValidationTask,

      THROWABLE EVENT
      {Description=[Failed to validate AR DB user sessions],Detail=[com.microsoft.sqlserver.jdbc.SQLServerException: User does not have permission to perform this action.]},

      Throwable=[com.microsoft.sqlserver.jdbc.SQLServerException: User does not have permission to perform this action.

      com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
      com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
      com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:440)
      com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:385)
      com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
      com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
      com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
      com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
      com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:367)
      com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDatabaseInformationValidationTask.validateMSSQLDatabaseInUseByDifferentUser
       (ARServerDatabaseInformatinValidationTask.java:5245)
      com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDatabaseInformationValidationTask.performValidation
       (ARServerDatabaseInformationValidationTask.java:373)  com.bmc.install.task.ValidationTask.execute(ValidationTask.java:54)
      com.bmc.install.task.InstallationTask.run(InstallationTask.java:93)
      java.lang.Thread.run(Thread.java:745)]
    ........................

     


    CAUSE:

    The user performing the installation/upgrade lacks the appropriate permissions.


    SOLUTION:

    In the same installation log it can be verified which authentication mode is being used during the installation:
    ......
    (Aug 13 2018 05:13:41.822 PM +0100),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,
      LOG EVENT {Description=
    [SET PROPERTY BMC_SQLSERVER_WINDOWSAUTH_OR_SQLAUTH],Detail=[WINDOWSAUTH]}
    ......

    In order to use Windows Authentication mode make sure the user has the correct permissions in both the Windows Server and the SQL Server.

    Check the following documentation:
    Windows Authentication mode and the Microsoft SQL Server

    Where it is stated:

    Windows authentication mode and the Microsoft SQL Server
    Choose one of the following authentication modes when you install the BMC Remedy AR System server:

    Windows authentication — For SQL Server environments that support only Windows authentication mode.
    When you use the Windows authentication mode with SQL Server note the following:

    1- To install or upgrade the BMC Remedy AR System Server on the Windows Server, you should log on the Windows Server with the domain account used for Windows authentication mode.

    2- The domain account used with Windows authentication mode should be a full administrator on the Windows Server and should have db_securityadmin and setupadmin roles in SQL Server.
    The domain account should be Database Owner (dbo) of the BMC Remedy AR System database.

    3- When the install or upgrade completes, it is possible to deny certain policies to the domain account used with Windows authentication mode for security reasons.
    The DBA should ensure that denying policies should not result in the loss of functionality.
    For any upgrades later, all the policy restrictions should be removed and the domain account should be returned to full administrator until the upgrade completes. 

    Windows authentication or SQL Server authentication — For SQL Server environments that support mixed authentication mode.
    To find the supported authentication mode for your SQL Server environment, connect to the SQL Server instance from Management Studio > Server Properties > Security.



     


    Article Number:

    000362991


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles