Problem with distributed transaction
-
Hi all, I got a problem with running distributed transactions between two servers that is connected via VPN connection (using RRAS). after the VPN connection is connected I can connect to the remote server with Microsoft SQL server management Studio and I can run query againts server. The problem occures when one of my store procedures start a distributed transaction and wants to insert at the remote server. (with just one insert command I can insert rows in the remote server but I can not wrap in a transaction) I got this error : "OLE DB provider "SQLNCLI" for linked server "172.26.0.11\CENTER" returned message "No transaction is active.". Msg 7391, Level 16, State 2, Procedure p_InsertPointOnline, Line 54 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "172.26.0.11\CENTER" was unable to begin a distributed transaction." I tried the following things : 1. turn off firewall in both sides. 2. Checking MS DTC security to allow outbound an inbound transactions on both sides 3. SET XACT_ABORT ON 4. SET REMOTE_PROC_TRANSACTIONS ON the strange thing is when I switched the firewall off and reconnect the VPN I got some transactions through. But the day after that the system did not work, after a lot of time I again turn the firewall back on with some added port as exceptions. Again it works until I disconnect the VPN and reconnect. I again turn the firewall off and reconnect the VPN it works again, you see the loooop :((!!! if any one could help me with this issue I would be gratefull. Hope you never stuck in such situations.
-
Hi all, I got a problem with running distributed transactions between two servers that is connected via VPN connection (using RRAS). after the VPN connection is connected I can connect to the remote server with Microsoft SQL server management Studio and I can run query againts server. The problem occures when one of my store procedures start a distributed transaction and wants to insert at the remote server. (with just one insert command I can insert rows in the remote server but I can not wrap in a transaction) I got this error : "OLE DB provider "SQLNCLI" for linked server "172.26.0.11\CENTER" returned message "No transaction is active.". Msg 7391, Level 16, State 2, Procedure p_InsertPointOnline, Line 54 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "172.26.0.11\CENTER" was unable to begin a distributed transaction." I tried the following things : 1. turn off firewall in both sides. 2. Checking MS DTC security to allow outbound an inbound transactions on both sides 3. SET XACT_ABORT ON 4. SET REMOTE_PROC_TRANSACTIONS ON the strange thing is when I switched the firewall off and reconnect the VPN I got some transactions through. But the day after that the system did not work, after a lot of time I again turn the firewall back on with some added port as exceptions. Again it works until I disconnect the VPN and reconnect. I again turn the firewall off and reconnect the VPN it works again, you see the loooop :((!!! if any one could help me with this issue I would be gratefull. Hope you never stuck in such situations.
Check which ports your firewall are blocking.
Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world." Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that." Deja View - the feeling that you've seen this post before.
-
Check which ports your firewall are blocking.
Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world." Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that." Deja View - the feeling that you've seen this post before.
The firewall on both sides are off. I discovered the reason but the do not know what to do exactly. The thing is that the remote server which is VPN server can not use netbios to reply to local server it can not resolve the Computer name. after the connection is made it is for about two seconds can reslove the name but after that it stop. I you know beside firewall what can cause such problem do not hesitate to tell me. Extra information : the remote server is win2003 local server is Winxp Pro both have sql 2005 standard edition No firewall software is installed and windows firewall is off. Thanks