September 2, 2010 at 8:05 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 3, 2010 at 12:59 pm
Enable "remote proc trans" using sp_configure on all the servers.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply