How can I specify the authentication type when using an 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 HCL Workload Automation 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 HCL Workload Automation database.

For more information about all parameters and supported values of the configureDb command, see Database configuration - configureDB script.