Hello Guys ,  I really need help in this ,

i was  created a linked server object to contact with other machine (Client) for manipulation data between two servers  using linked server  and transaction as validation if any error happens.

i configure the local DTC to allow inbound, allow outbound and no authentication required to make the transaction works,  and the MSDTC service is running .

every thing work fine until the main server is moved to another place and IP address changed .

now , when i try to  make select statement from both the server and the client is work fine  but when i try to make update statement nothing works and the error is ' No Transaction Is Active ', 'unable to start distributed transaction for the linked server '.

NOTES:

1- The server is windows server 2008 R2 Enterprise Edition  , the client is windows 7 64 bit .

2-  I used SET XACT_ABORT ON command for each transaction .

3- Firewall is disabled .

4- Sql sever default port is open 1433 for both server and client.

5- MSDTC  port 135 is open 135 for both server and client .

You need to configure the DTC

refer 

http://itknowledgeexchange.techtarget.com/sql-server/how-to-configure-dtc-on-windows-2008/ 

vt

Thank you for your reply,

the DTC is configured as the refer link , but still the same issue 

Hello Guys , 

I really need help in the previous problem ,

anyone can help.

thanks in advance.

Hi haetham,

Please run SQL Server Best Practice Analyzer to detect situations where the MSDTC is not configured properly, additionally please refer to the following links to enable Network Access Securely for MS DTC and Network DTC Access.

Recommended MSDTC settings for using Distributed Transactions in SQL Server
http://support.microsoft.com/kb/2027550/en-us

Enable Network Access Securely for MS DTC
http://technet.microsoft.com/en-us/library/cc753620(WS.10).aspx

Enable Network DTC Access
http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx