Follow the instructions up to Step 2, as documented in Configure for 以下指引承接 配置 MS SQL Server 2005 步骤2. Then, we will need to enable the listener port necessary for Joget to establish a connection to.
...
然后,我们需要启用一个监听端口用于连接.
步骤 3: 启用Microsoft SQL Server 2012 TCP/IP
Figure 1: Sql Server Configuration Manager
- Enable 启用Enable named pipes and TCP/IP.
- Open up 打开 TCP/IP Properties属性.
Figure 2: IP2 - TCP/IP Properties Under Protocols for SQLEXPRESS
- Right-click on 右键点击 TCP/IP and select Properties选择 属性.
- Go to 选择 IP2, set your local IP Address in 设置您的本地 IP 地址 IP Address.
- Remove 移除 TCP Dynamic Ports value 值.
Figure 3: IPALL - TCP/IP Properties Under Protocols for SQLEXPRESS
- Go to 选择 IPAll.
- Empty 清空 TCP Dynamic Ports value 值.
- Set 设置 TCP Port value to 端口为 1433.
Figure 4: Restart SQL Server Service for changes to take effect
- Restart the server for the changes to take effect重启服务.
Figure 5: Verify the listening port using command prompt
- Verify that the listener is working through command prompt by executing 执行 netstat -aoao 命令检查监听是否已工作.
Figure 6: Verify instance based on the PID
- Check on which process instance is listening to the port by executing 执行 tasklist /fi "pid eq 4488" 命令检查监听线程ID.