September 2, 2010 at 5:25 am
Hi,
I have been trying to run a distributed transaction query from SQL server 2008 SP1 installed on Windows 2008 server from last 1 week. Other server is also with same configuration(SQL 2008 SP1+Windows 2008).
I have configured all the MSDTC options in both the server. Firewall is disabled in both the server.
I am able to create linked server and also ran the normal query.It worked fine. But if I am running same query with BEGIN DISTRIBUTED TRAN, I am getting error as:
"OLE DB provider "SQLNCLI10" for linked server "sql-01" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 2
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "sql-01" was unable to begin a distributed transaction.
Query was cancelled by user."
Also i have insatalled the hotfix provided by Microsoft for SQL 2008 SP1.
For your information, I am doing all these setup on amazon ec2(cloud service).
Please help me. Thanks in advance.
Shailesh
September 2, 2010 at 9:02 am
In server properties -> Connections, look for "Require Distributed Transactions for server to server communication" and enable (on both servers)
September 3, 2010 at 1:34 am
I have already done these settings but still no luck. I applied the hotfixes provided by Microsoft for SQL server SP1 also.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply