Installing Microsoft SQL Server

Before you install HCL Workload Automation for the first time, you must have Microsoft SQL Server installed. Ensure you downloaded the JDBC driver for Microsoft SQL Server, including the following prerequisites libraries and class library files :

• sqljdbc_auth.dll
• sqljdbc4.jar
• sqljdbc.jar

Also, before you create the HCL Workload Automation schema on the database, you must have created the directory where the HCL Workload Automation table spaces will be placed when the HCL Workload Automation schema is created. The default is C:\MSSQL.

To have a working HCL Workload Automation schema on your Microsoft SQL Server database, you must follow these steps:

1. Run the procedures described in Creating or upgrading the database schema if you are using Microsoft SQL Server.
2. Install a master domain manager, a dynamic domain manager, or their backups.
3. Configure the master domain manager, dynamic domain manager, or their backups to connect with the database as described in Installing for a Microsoft SQL Server database.