Home > DTC, DTC, SQL Server, SSIS > Configure DTC on Windows Server 2003/ Windows XP

Configure DTC on Windows Server 2003/ Windows XP

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.

Advertisements
Categories: DTC, DTC, SQL Server, SSIS
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: