Skip to Content

Unable to install TrueSight Smart Reporting on Windows because of a database error 1

If you are installing TrueSight Smart Reporting by using the SQL Server database and the authentication mode is Windows, you might see the following message, and the installation does not proceed:

An error occurred during installation:
com.hof.dbtool.DBException: Error executing update
ERR_UPDATEQUERY
Query:

ALTER AUTHORIZATION ON database:yellowfin TO <domain name>\<login name>

Related topic

Installing

Solution

  1. Manually create the database.
  2. In the command line interface, run the following command:
    alter authorization on database::yellowfin TO "<domain name>\<login name>"
  3. Launch the installer and start the installation process.
  4. While entering the database details, clear the Create new database check box.
  5. Enter the details of the database that you manually created.
  6. Complete the installation process.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

TrueSight Smart Reporting 19.01