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

Use the green_square_iconbutton next to "SQL connection" to select whether the database will be created on a local machine or an SQL server:

SQL_connection_preset

Then configure the database parameters depending on the chosen option: SQL Express or SQL Local DB.

SQL Express Database

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_buttonbutton 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 "Check database" button to check validity of the selected database and create one if required.

SQL Local Database

The internal database based on the MS SQL Local DB database engine suits evaluation purposes only; it works out of the box and requires no additional setup. However, we strongly recommend using an external database as a back-end Cinegy PCS database in a production environment. An external database is usually more reliable and provides better performance. Also, the internal database may become extremely slow on large data sets. Please also note that our support does not cover any performance or database data loss issues if you are using the internal database.

Caution
Please pay special attention that we strongly recommend not to use internal MS SQL Local DB database for production Cinegy PCS instances.
Important
The Cinegy LocalDB Provider installation is required for creation of a local Cinegy PCS database. The local database is configured automatically by the Cinegy LocalDB Provider service.

Specify the database name:

Localdb_name

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.