Creating the Scheduler Service Database

After installing Worksoft Infrastructure Services, you need to create databases for the following:

• Authentication Service
• Worksoft Portal
• Scheduler service

The Authentication service and Worksoft Portal databases need to be created before you create a Scheduler service database. In order to create databases, the user must have SQL Server dbcreator permissions.

Registering the Scheduler Service

The first time an administrator signs in to Worksoft Portal, the Scheduler service registers automatically.

From the Worksoft Portal menu, select Product Configuration > Scheduler to verify the registration.

If for some reason the product does not automatically register, you can trigger the registration manually. For more information, see Manually Registering Products and Services for the Worksoft Portal.

To create the Scheduler service database:

1. From the Worksoft Portal menu, select Product Configuration > Scheduler.

   The Scheduler Connection Setup screen opens.

   

2. In the Database Configuration section, enter the following information in the respective fields:
3. SQL server
4. Database name
5. SQL user name
6. SQL password

In order to configure a database, the user must have SQL Server dbcreator permissions.

3. If you want to use Windows Authentication instead of SQL Server Authentication, select the Use Trusted Connection (Windows) option.

4. To prevent database permission issues, select the Trust Server Certificate option.

5. Click Test to test the connection.

6. Click Save.

   The Scheduler database connection is saved.

 

Related Topics