Create the Database

SQL Server

  1. Connect to your SQL Server
  2. Create a database named colectica_workflow
  3. Run the SQL commands in Datacolectica_workflow.sqlserver.sql of the Colectica Workflow Service package
  4. Give the LocalService account, or the user account that will run the workflow service, access to the colectica_workflow database.
  5. Give the LocalService account, or the user account that will run the workflow service, access to all colectica repository databases you wish to configure.

PostgreSQL

  1. Connect to your PostgreSQL server
  2. Create a database named colectica
  3. Run the SQL commands in Data\colectica_workflow.postgresql.sql of the Colectica Colectica Workflow Service package