We have tested Joget Workflow v3 with Microsoft SQL Server 2005. However, if you have found find any issue(s), please feel free to inform the community through forum discussion.
- Create a database in SQL Server, ; name it as jwdb (or other preferred database name).
- Make sure that you grant the intended database user with sufficient access to "jwdb".
- Download jwdb-mssql.sql, and and load this SQL file to "jwdb". This will populate all necessary Joget Workflow table structure structures into "jwdb".
- In joget-installation-directory/wflow/, create a new datasource profile file - app_datasource-mssql.properties.
- Open to edit joget-installation-directory/wflow/datasource-mssql.properties in text editor, and 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.
- Open to edit joget-installation-directory/wflow/app_datasource.properties in text editor, and and change the content to as shown in Figure 2 below. This is to activate the datasource profile named "mssql".
- Restart Joget Workflow server.
...