Create the Database#
SQL Server#
Connect to your SQL Server
Create a database named colectica_workflow
Run the SQL commands in
Datacolectica_workflow.sqlserver.sql
of the Colectica Workflow Service packageGive the
LocalService
account, or the user account that will run the workflow service, access to thecolectica_workflow
database.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#
Connect to your PostgreSQL server
Create a database named
colectica_workflow
Run the SQL commands in
Data\colectica_workflow.postgresql.sql
of the Colectica Colectica Workflow Service package