¶ Use
If the VenioPCD database is located on a different SQL server instance than some (or all) of the project databases, the Microsoft Distributed Transaction Coordinator (MSDTC) service must be running on all SQL servers.
¶ Prerequisites
The same SQL username and password used in the server which hosts the VenioPCD must be added to the new SQL server which will be utilized as a linked server. This SQL account must be added to systemadmin role.
Be sure to chage "test" to the same account name which the venio PCD server instance utilizes. Ensure it uses the same password as the VenioPCD server instance account also.
Add the Venio SQL account to the sysadmin role
¶ Enabling MSDTC service for Venio
To enable MSDTC service:
- Choose Start > (All) Programs > Administrative tools > Component Services.
- Expand Computers and choose My Computer.
- Right-click My Computer, choose Distributed Transaction Coordinator, right-click Local DTC and choose Properties > Security.
- Select options Network DTC Access, and Enable XA Transactions.
- In Transaction Manager Communication, select the options Allow Inbound,Allow Outbound, and No Authentication Required.
- In the Security Configuration dialog box, click OK.
- In the My Computer Properties dialog box, click OK.
FigureEnabling MSDTC
Note: The screenshots used in the procedure may differ from the user interface you have since they are not updated when the user interface changes. They are merely used to give a better idea of the configuration procedure.
To start the DTC service,
- Choose Start > Programs > Administrative tools > Services.
- Choose the Distributed Transaction Coordinator service.
- Set the startup type to Automatic, and start it up.
¶ Adding the Linked Server in Venio Console
Login to Venio as Venio Admin
Click the tab Administration --> Configure Server
CLick the Database Server tab, then add the details as necessary
Click "Check Server Status" to ensure proper configuration.
¶ Checking status through Health Checkup utility
Uncheck 'Select All' checkbox
Select only the checkboxes under the Module Name: SQL Database --> Execute Tests
If you receive any failed tests, highligh the test which failed and clicked "Detailed Report"
This report may contain useful steps to resolve the issue.