Caution
The database is created on an SQL server while configuring Cinegy Process Coordination Service. It is a separate unit, which is not related to Cinegy Archive database.

SQL Express Database Configuration

PCS_configurator
  • Data source – specify the existing SQL Server instance name using the keyboard.

  • Initial catalog – define the database name.

  • Authentication – use the drop-down list to select whether the Windows or SQL Server authentication will be used for access to the created database. With the "SQL Server Authentication" option selected, the required field becomes highlighted with a red frame; press the expand_settings_button button to expand the "Authentication" settings:

    User_credentials

    Type in the username and password in the corresponding fields.

    Note
    Please mind that the database settings cannot be saved until all required fields are filled in; the red indicator shows a tooltip explaining the reason why settings cannot be applied.
  • Attached filename – specify the path to the database file. This option can be left empty for most configuration scenarios. Modifications are recommended for advanced users only.

Check_database_button

Press the "Manage database" button to check validity of the selected database and create one if required.

Database Validation

Having pressed the "Check database" button, you will see the "Database validation" dialog with the four steps of the database check:

PCS_database_validation

The following color indication is used for each validation step status:

checking_status_in-progress

database parameter is being checked

checking_status_valid

database parameter is valid

checking_status_pending

database parameter validation is pending

checking_status_invalid

database parameter is invalid

Stop_validation_button

Press the "Stop" button if you need to stop the database validation process.

Conclusion_section

If database check reveals problems on any step of validation, the invalid parameter becomes highlighted and the detailed explanation is given in the "Conclusion" section:

Database_invalid_conclusion

Log_section

Switch to the "Log" section to view the validation log details:

Database_invalid_log

Create_a_database_button

If validation reveals that the specified database does not exist, press the "Create a database" button.

Updating_data_button

If validation reveals that any database parameter is outdated, press the "Updating data" button.

Press "OK" to confirm applying the fix of any invalid database parameter, press "Yes" in the dialog that appears:

Confirmation_dialog

The following dialog gives the detailed information on the database creation progress:

Create_a_database_dialog

The following dialog gives the detailed information on the progress of updating:

Updating_database_window

Wait until the updating process is finished.

The following dialog informs you about successful database creation:

Database_created_successfully

The following dialog informs you about successful updating completion:

Update_completed

Press "OK" to exit the dialog.

Note
With failure of any parameter validation, a respective button will appear on the bottom right corner of the window, pressing which will apply a required fix to the problem.

Validate_button

Once the fix is successfully applied to the invalid parameter, press the "Validate" button to repeat the parameter check.

When the database validation is finished successfully, press "OK" to proceed with the PCS configuration.

Apply_button

Having completed specifying the database settings, press the "Apply" button to save them.

Discard_button

If you do not want to save the specified settings, press the "Discard" button.

Go to the "Windows service" tab to proceed with Cinegy PCS configuration.