IBM Support

Database schema cannot be updated after upgrading License Metric Tool to application update 9.2.28

How To


Summary

After you upgrade License Metric Tool to application update 9.2.28, you are not able to update the License Metric Tool database schema.

Objective

After you click Update Schema, the following message is displayed:
"Database error. A user's default schema must be set to 'dbo'. Currently, it is set to guest. Before you can use the database, change its default schema."

Environment

License Metric Tool v9.2 that uses MS SQL Server database.

Steps

The problem occurs when the MS SQL Server user account that is used by License Metric Tool is not a member of the sysadmin Fixed Server Role. In such case, the IBM License Metric Tool server checks the MS SQL Server user's default schema in the default database that is assigned to this account. By default, it is the MS SQL Server 'master' database while the check is meant to be run against IBM License Metric Tool database. As a result, validation of the default schema might fail as it is checked against incorrect database.
Resolving the problem:
  1. Log in to the computer where the IBM License Metric Tool server is installed and go to the following directory: <ILMT_install_dir>\wlp\usr\servers\server1\config (where <ILMT_install_dir> is the License Metric Tool server installation directory).
  2. Open the database.yml file and take note of the database name and the MS SQL Server user information. If instead of the user information you see the "windows_authenticated: true" string, check the Windows user account that is specified as the "Log On As" in the definition of the IBM License Metric Tool 9.2.28.0 Windows service.
  3. Open SQL Server Management Studio (SSMS) and change the default database for the account that is used to log in the to License Metric Tool database (by default, temadb). You can complete this task in two ways:
    • By using Object Explorer
      1. In Object Explorer, open Security > Logins.
      2. Right-click the user that you created and click Properties.
      3. On the General page, under Default database, select the database that is used for the License Metric Tool server (by default temadb).
    • By using SQL Query command
      ALTER LOGIN <login account> WITH DEFAULT_DATABASE = <License Metric Tool server database>
             For example: ALTER LOGIN [NT AUTHORITY\SYSTEM] WITH DEFAULT_DATABASE = temadb
Ensure that you choose the user account that is used by the License Metric Tool server. If the server runs by using the 'Local System' account (this account is selected during the default installation), that account is listed as 'NT AUTHORITY\SYSTEM' in SQL Server Management Studio.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS8JFY","label":"IBM License Metric Tool"},"ARM Category":[{"code":"a8m0z000000CbhrAAC","label":"LMT Install\u0026Upgrade"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
07 September 2022

UID

ibm16602607

Page Feedback