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. 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.

Database Connection Configuration Options

When you configure your Scheduler database, you can select how you want to set up your database security configuration. You need to be a superuser to configure both connections:

• User Based Configuration
• Managed Service Identity Configuration

To create a Scheduler service database with a user-based configuration connection:

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

   The Database Configuration page opens.

   

2. Select the User Based Configuration option.

3. In the SQL Server field, enter the server name.
4. In the Database Name field, enter the database name.

5. If you want to use Windows authentication, select the Use Trusted Connection (Windows) option.

   For more information about configuring Windows authentication, see Chapter 2 in the Worksoft Infrastructure Services Installation Guide.

6. If you want to use SQL Server authentication, enter the SQL Server user name and password in the respective fields.

7. Select the Trust Server Certificate option.

8. Click Test to test your database connection.

   A message opens stating if the connection was successful or failed. If the test fails, troubleshoot the database connection.

9. Click OK to close the message.

10. Click Save to save your database.

    A message opens stating the connection was successful.

To create a Scheduler service database with a Managed Service Identity configuration connection:

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

   The Database Configuration page opens.

   

2. Select the Managed Service Identity Configuration option.

3. In the Database Server field, enter the server name.
4. In the Database Name field, enter the database name.
5. In the Managed Identity ID field, enter the ID.

6. Click Test to test your database connection.

   A message opens stating if the connection was successful or failed. If the test fails, troubleshoot the database connection.

7. Click OK to close the message.

8. Click Save to save your database.

   A message opens stating the connection was successful.

 

Related Topics