Page History

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

workflowDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
workflowUrl=jdbc\:sqlserver\://host\:1433;DatabaseName\=jwdb;SelectMethod\=cursor
workflowUser=username
workflowPassword=password

You may need to change the datasource URL, database user and database user's password accordingly.

Step 2: datasource.properties

currentProfile=mssql

Step 3: Enabling TCP/IP on Microsoft SQL Server 2005

In order to connect to the Microsoft SQL Server remotely (such as JDBC datasource), TCP/IP needs to be enabled. This is disabled by default on Microsoft SQL Server 2005 Express edition. TCP/IP may also be manually disabled on other editions of Microsoft SQL Server 2005.

...