sqlserver2008 the stored procedure configuration process in a linked server

Reference: http://www.cnblogs.com/ycsfwhh/archive/2010/12/15/1906507.html

1. Both sides start the MSDTC service
MSDTC (Distributed Transaction Coordinator) that coordinates transactions across multiple databases, message queues, file systems, and other resource managers. The process name of the service is Msdtc.exe, which calls the system Microsoft Personal Web Server and Microsoft SQL Server. This service is used to manage multiple servers.
Location: Control Panel--management tool--service--distributed Transaction Coordinator
Dependencies:Remote Procedure Call (RPC) and security Accounts Manager
Recommendation: General home computers are not covered unless you enable the Message Queuing service to stop.

Workaround:(1) on Windows Control Panel--Administration Tools--service-->distributed Transaction coordinator--> Properties--Start (2) Running "net start msdtc" under CMD is normal after the service is turned on .

Note : If the 1th step distributed Transaction coordinator fails to start, the log file is lost, the log file is recreated, and then it is started. To re-create the MSDTC log and restart the service, follow these steps:
(1) Click "Start", click "Run", enter cmd and press "OK".
(2) Input: Msdtc-resetlog (Note When you run this command, do not perform a pending transaction)
(3) Last input: net start MSDTC enter, done!

Both computers do the following configuration (windows2003 system):

2. Click Add/Remove Windows components.  
3. Select Application Server, and then click Details.  
4. Select Enable network DTC access, and then click OK. &NBSP
5. Click Next, and click Finish. &NBSP
6. In Start, run, enter Dcomcnfg.exe to start Component Services.
7. Right-click "My Computer" and "Properties", on the MSDTC tab, click on the "Security Configuration" button.
8. In the Security Configuration window, make the following settings:
(1) Select "Network DTC Access"
(2) In Client management, select "Allow remote Clients" "Allow Remote Administration"
(3) in the Transaction management communication, select "Allow Inbound" "Allow Outbound" "Do not require authentication"
(4) Guaranteed DTC login account: NT authority\networkservice
(5) Click OK. This will prompt you to "MS DTC will be stopped and restarted." &NBSP
   All dependent services will be stopped. Please press ' yes ' to continue. Click "Yes" to continue.  
9.  Shut down the network firewall (either open the appropriate port 135 or start the TCP/IP NetBIOS Helper service with Services.msc Open service)

Both computers do the following configuration (windows2008 system):
2.  click Control Panel.
3. Open programs and features.
4. Click Turn Windows features on or off.
5. Expand Roles, Application server, Component Services, right-click Local DTC
6. Select the Security tab of local DTC and do the following:
(1) Select Network DTC Access
(2) In Client management, select "Allow remote Clients" "Allow remote Administration"
(3) in the Transaction management communication Select "Allow Inbound" "Allow Outbound" "Do not require authentication"
(4) Ensure that the DTC login account is: NT authority\networkservice
(5) Click OK. This will prompt you to "MS DTC will be stopped and restarted." &NBSP
   All dependent services will be stopped. Please press ' yes ' to continue. Click "Yes" to continue. &NBSP
7. Shut down the network firewall (either open the appropriate port 135 or open the TCP/IP NetBIOS Helper service with services.msc to start the service)