Page History

1. Create a database in SQL Server; name it 在SQL Server中创建一个数据库; 命名为 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.sql and load this SQL file to  并加载到 "jwdb". This will populate all necessary Joget Workflow table structures into 这将在 "jwdb" 中为Joget Workflow创建所需的数据表.
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. 插入以下内容如步骤1. 您需要根据实际情况编辑配置 (例如datasource URL, 数据库用户名/密码).
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 如步骤2. 它将激活 "mssql" 配置文件为当前数据库连接.
7. Restart重启 Joget Workflow serverWorkflow服务.

...

步骤1: 数据库连接配置

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.

...

步骤2: 数据库当前有效连接配置 datasource.properties

currentProfile=mssql

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

步骤3: 启用 Microsoft SQL Server 2005 TCP/IP

为了允许远程连接 In order to connect to the Microsoft SQL Server remotely (such as JDBC 例如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 edition中默认未启用. 

启用 Microsoft SQL Server 2005 .To enable TCP/IP on Microsoft SQL Server 2005:

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.是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然后点击 ‘Enable’. Icon将显示为启用.