How can I specify the authentication type when using an MSSQL database?

Configuring the authentication type for the MSSQL database.

When using an MSSQL database, you can choose between two different authentication types:
  • MSSQL authentication. This is the default value.
  • Windows authentication
To define the authentication type, proceed as follows:
  1. Browse to the folder containing the configureDb command. The command is located in the following path, depending on the component for which you are installing:
    master domain manager
    image_location/TWS/interp_name
    Dynamic Workload Console
    image_location
  2. When launching the configureDb command, as explained in Creating and populating the database, specify the auth_type argument with one of the following values:
    SQLSERVER
    Enables MSSQL authentication type. Only the user specified with the --dbadminuser argument has the grants to administer the IBM® Workload Scheduler database. This is the default value.
    WINDOWS
    Enables Windows authentication type. The Windows user you used to log on to the workstation is assigned the grants to administer the IBM Workload Scheduler database.
For more information about all parameters and supported values of the configureDb command, see Database configuration - configureDb script.