HCL Workload Automation, Version 9.4

Procedure to create the dynamic workload broker SQL schema on Microsoft SQL Server when using Windows Authentication

To create the dynamic workload broker database when using Windows Authentication, run the following steps:

From the workstation where the Microsoft SQL Server is installed, start a shell in which you impersonate the domain user that will later be the owner of the HCL Workload Automation instance.
Go to the following directory:
```
TWSTEMPDIR\TDWB\dbtools\mssql\scripts
```
Where TWSTEMPDIR is the directory you specified in the TWSTEMPDIR property of the configuration file. For more information about how to customize the property file, see Customizing the properties file for Microsoft SQL Server.
Run the following command:
```
createdb_root.bat 
<sqlServerInstance> <windowsAuthMode>
<twsDatabase> <agentType>
```
Where:
<sqlServerInstance>

The name of the SQL Server instance.

<windowsAuthMode>

Specifies if Windows authentication is used to connect to SQL Server. Enter TRUE if you are authenticating as Windows user.

<twsDatabase>

The name of the database. The default value is TWS.

<agentType>

The type of HCL Workload Automation component for which you are creating the SQL tables. Enter:
MDM

If the dynamic workload broker for which you are creating the SQL tables resides in a master domain manager.
Attention: Start this procedure only after the master domain manager database is created.

BKM

If the dynamic workload broker for which you are creating the SQL tables resides in a backup master domain manager.
Attention: Start this procedure only after the backup master domain manager database is created.

DDM

If the dynamic workload broker for which you are creating the SQL tables resides in a dynamic domain manager.

BDM

If the dynamic workload broker for which you are creating the SQL tables resides in a backup domain manager.
Attention: Start this procedure only after the dynamic domain manager database is created.