Archive

Archive for the ‘DTC’ Category

Configure DTC on Windows Server 2003/ Windows XP

June 11, 2009 Leave a comment

For the transactions to run successfully across  servers , we need to enable DTC ( distributed transaction coordinator). For example, while running a ssis package with transactions running across servers we might encounter an error related to DTC. To avoid these errors we have to enable DTC on both the machines.

This post discusses about enabling DTC.

We can do this by Add/Remove Windows Components in Add/Remove Programs under the control panel.  When the Windows Components Wizard opens, select Application Server and click on details.  Select “Enable network DTC access” check box.

untitled

After that, finish running through the wizard and network DTC will be installed. We still need to configure DTC.  To do this, open the Component Services MMC from the Administrative Tools menu.

untitled1

Right click on “My computer” and select properties, then the MSDTC tab. In MSDTC tab, select the Security configuration button. check/Uncheck  the properties as required. click on OK button.

untitled2

Restart the DTC service on your machine for the changes to take effect. If you still encounter errors while running packages/queries , you may have to restart your machine once.

Categories: DTC, DTC, SQL Server, SSIS