http://www.cnblogs.com/Isabella/articles/504004.html
Reason:
Either the Microsoft Distributed Transaction Coordinator (MSDTC) service is not running, or your Renaissance Place(a application) application is installed to more than one server (separate database, application, and/or report servers) running Windows Server 2003. The enhanced security built in to Windows Server 2003 may prevent the MSDTC service from functioning as required. This is generally only an issue if the following are true:
- Renaissance Place is running on separate application and database servers.
- One or more of the Renaissance Place servers are running Windows Server 2003.
- The Renaissance Place servers are part of a domain but do not have an established trust relationship, or the servers are part of a Windows workgroup.
You may also experience this problem after updating to Windows Server 2003 Service Pack 1. The Service Pack 1 update adds new capabilities for managing DTC and automatically enables RPC security, preventing all distributed transactions in Renaissance Place in certain environments.
Resolution:
Windows 2000 Server
To start the MSDTC service:
1) Open Computer Management, open Services and Applications, and click on Services on the left side of the screen.
2) In the list of services on the right, locate Distributed Transaction Coordinator and double-click on it.
3) Change the Startup Type to Automatic and click on the [Start] button to start the service.
4) Click on [OK] to accept the changes.
Windows Server 2003
To start the MSDTC service:
1) Open Computer Management, open Services and Applications, and click on Services on the left side of the screen.
2) In the list of services on the right, locate Distributed Transaction Coordinator and double-click on it.
3) Change the Startup Type to Automatic and click on the [Start] button to start the service.
4) Click on [OK] to accept the changes.
If you have separate database, application, and/or report servers, you will need to ensure the service is started on all Renaissance Place servers.
If Renaissance Place is running on separate application and database servers, follow these instructions on each of your Renaissance Place servers running Windows Server 2003. First, make sure DTC transactions are supported on all Renaissance Place servers:
1) Click Start, point to Control Panel, and start the Add or Remove Programs application.
2) Select Add/Remove Windows Components, select the Application Server component, and click [Details].
3) If “Enable network DTC access” is checked, skip to the next section of this article. If it is not checked, check this option and click [OK], then click [Next]. You may be prompted to insert your Windows Server 2003 CD-ROM.
4) Click [Finish] when the install is complete and close the Add or Remove Programs application.
Next, follow these instructions to disable RPC security .
On each of your Renaissance Place servers running Windows Server 2003 Service Pack 1:
1) Click Start -> All Programs -> Administrative Tools -> Component Services.
2) Open Computers, right-click on My Computer, and choose Properties.
3) Click on the [MSDTC] tab and click on the [Security Configuration] button.
4) Under the Transaction Manager Communication section, change the setting to “No Authentication Required” and click [OK].
5) Confirm [Yes] to stop and restart MS DTC.
6) Click [OK] to confirm the alert, click [OK] to close My Computer properties, and close Component Services.
7) Restart the computer.
If one or more of your Renaissance Place servers are running Windows 2003 WITHOUT Service Pack 1 installed, you must manually disable RPC security using REGEDIT. NOTE: This requires accessing and modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs.
1) Click Start, click Run, type regedit, and click [OK].
2) Expand HKEY_LOCAL_MACHINE, then SOFTWARE, then Microsoft.
3) Right-click on MSDTC, point to New, then select DWORD Value.
4) Rename the key from the default New Value #1 to TurnOffRpcSecurity.
5) Double-click the new key and change the value to 1, then click [OK].
6) Close the Registry Editor and restart the computer.
You may now resume using Renaissance Place.
If you have made the appropriate changes to DTC but errors persist, note that DTC also requires that you are able to resolve computer names by way of NetBIOS or DNS. You can test whether or not NetBIOS can resolve the names by using ping and the server name for each of the Renaissance Place servers. The application and reports servers must be able to resolve each other as well as the name of the database server, and the database server must be able to resolve the application and reports servers.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=230390&SiteID=1
First verify the "Distribute Transaction Coordinator" Service is
running on both database server computer and client computers
1. Go to "Administrative Tools > Services"
2. Turn on the "Distribute Transaction Coordinator" Service if it is not running
If it is running and client application is not on the same computer as
the database server, on the computer running database server
1. Go to "Administrative Tools > Component Services"
2. On the left navigation tree, go to "Component Services > Computers
> My Computer" (you may need to double click and wait as some nodes
need time to expand)
3. Right click on "My Computer", select "Properties"
4. Select "MSDTC" tab
5. Click "Security Configuration"
6. Make sure you check "Network DTC Access", "Allow Remote Client",
"Allow Inbound/Outbound", "Enable TIP" (Some option may not be
necessary, have a try to get your configuration)
7. The service will restart
8. BUT YOU MAY NEED TO REBOOT YOUR SERVER IF IT STILL DOESN'T WORK
(This is the thing drove me crazy before)
On your client computer use the same above procedure to open the
"Security Configuration" setting, make sure you check "Network DTC
Access", "Allow Inbound/Outbound" option, restart service and computer
if necessary.
On you SQL server service manager, click "Service" dropdown, select
"Distribute Transaction Coordinator", it should be also running on
your server computer.
Hope it helps,