You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

We have tested Joget Workflow v3 with Microsoft SQL Server 2005. However, if you have found any issue, please feel free to inform the community through forum discussion.

  1. Create a database in SQL Server, name it as jwdb (or other preferred database name).
  2. Make sure that you grant the intended database user with sufficient access to "jwdb".
  3. Download jwdb-mssql.sql, and load this SQL file to "jwdb". This will populate all necessary Joget Workflow table structure 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/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 to as shown in Figure 2 below. This is to activate the datasource profile named "mssql".
  7. Restart Joget Workflow server.

Figure 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.

Figure 2: datasource.properties

currentProfile=mssql

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.

To enable TCP/IP on Microsoft SQL Server 2005:

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