Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. Create a database in SQL Server; name it jwdb (or another preferred database name).
  2. Make sure that you grant the intended database user with sufficient access to "jwdb".
  3. Download jwdb-mssql-ddl.sql and load this SQL file to "jwdb". This will populate all necessary Joget Workflow table structures into "jwdb".
  4. In joget-installation-directory/wflow/, create a new datasource profile file - app_datasource-mssql.properties.
  5. Open to edit joget-installation-directory/wflow/app_datasource-mssql.properties in text editor and insert contents as shown in Figure 1 below. You may need to edit the configurations (such as datasource URL, database user/password) according to your environment.
  6. Open to edit joget-installation-directory/wflow/app_datasource.properties in text editor and change the content as shown in Figure 2 below. This is to activate the datasource profile named "mssql".
  7. Restart Joget Workflow server.

Step 1: Datasource Profile Configurations

...

  1. In Microsoft SQL Server 2005 -> Configuration Tools, open 'Microsoft SQL Server Configuration Manager'.
  2. Expand ‘SQL Server 2005 Network Configuration’ and then click on ‘Protocols for <Instance Name>’.  <Instance Name> is the name of the database instance used by Joget Workflow.
  3. Right-click on ‘TCP/IP’ and then click on ‘Enable’. The icon for the protocol will change to show that the protocol is enabled.