This document describes how to connect Kingdee K/3 WISE 15.0/15.1 to TencentDB for SQL Server so as to execute distributed transactions between the TencentDB for SQL Server and Windows CVM instances.
This solution consists of the following three steps:
- To support distributed transactions, additional resources are required for configuration; therefore, you can configure instances only in specification higher than "1-core 4 GB MEM". Please upgrade the instances that do not meet the minimum requirement before connection.
- Adjust the TencentDB for SQL Server access settings to ensure that distributed transaction can be executed. You can submit a ticket for assistance. To improve the ticket processing efficiency, make sure that you have already read this document and completed data migration to TencentDB for SQL Server before submitting the ticket.
Prerequisites: you have backed up the full data of the account set database files in your local Kingdee K/3 WISE instance.
The CVM instance where Kingdee is installed and the TencentDB for SQL Server instance must be in the same VPC in the same region.
Adjust the TencentDB for SQL Server access settings to ensure that distributed transactions can be executed. You can submit a ticket for assistance.
hosts file located at
Add the VIP and host information (which can be obtained by submitting a ticket) provided by TencentDB for SQL Server to the end of the
hosts file and save the change.
Open "Component Services" in "Control Panel" > "System and Security" > "Administrative Tools".
Select "Component Services" > "Computers" > "My Computer" > "Distributed Transaction Coordinator".
Right-click the local DTC on the right and select "Properties".
Select the "Security" tab, set as follows, and click OK.
In the pop-up MSDTC service dialog box, click Yes and wait for the MSDTC service to restart.
Download the account set management tool: Kingdee K/3 WISE 15.1 or 15.0.
The required account set management tool varies by Kingdee K/3 WISE version.
Decompress the package and replace the files in the Kingdee installation directory
K3ERP\KDSYSTEM\KDCOM with the extracted files.
Open Kingdee K/3 WISE.
On the pop-up account set management database settings page, set relevant identity verification information and data server.
Enter the private network address of the TencentDB for SQL Server instance as the data server, which can be viewed in the console.
In the "System" drop-down list, click Preset Connection and set the preset connection for easier use.
In the database drop-down list, click Register Account Set.
Select the corresponding database and click All.
After you complete all the settings above, distributed transactions can be supported between the CVM and TencentDB for SQL Server instances, and you can log in to and use Kingdee K/3 WISE normally.
If the following error message is displayed during login:
Failed to create the transaction at the intermediate layer. Please contact the system administrator. Advanced display: error code: 5(5H)
Please troubleshoot the error as instructed in Kingdee's official documentation.