x

SQL Red Gate Compare

Hi,

I tried to synchronize the Database between 2 Servers using Red Gate Compare, I am getting the following error.


[7391] The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "PRODUCT_SERVER" was unable to begin a distributed transaction. OLE DB provider "SQLNCLI10" for linked server "PRODUCT_SERVER" returned message "The partner transaction manager has disabled its support for remote/network transactions.".

Anybody got that error before? Do you know how to resolve that issue?

Thanks.
more ▼

asked Nov 29, 2010 at 04:51 AM in Default

Leo gravatar image

Leo
1.6k 54 56 58

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

This came up once before here on ASK. You might want to [look here][1] and see if you're dealing with a related issue.

[1]: http://ask.sqlservercentral.com/questions/6109/cant-use-linked-servers-in-view
more ▼

answered Nov 29, 2010 at 05:26 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

Hi Grant,

Thank you very much. I have changed

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE => READ COMMITTED

in Script and run it under the Development Server and it works perfectly.
Nov 29, 2010 at 05:43 AM Leo
Excellent. And that's a good blog post. I'll add it to the stack.
Nov 29, 2010 at 06:14 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

It sounds like the Distributed Transaction Coordinator (DTC) must be offline on the server. Or, DTC is set to not allow remote connections. Either way, you'll need to go to the server to do this.

Is is possible you're running SQL Compare across different domains? I only ask because I wouldn't have expected it to need to do a distributed transaction... unless there are also linked servers involved, maybe... Not sure about that.
more ▼

answered Nov 29, 2010 at 05:23 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

Hi Grant,

You are right, that is error on Linked Server. We used the linked server in stored procedure. I already check the main server to make sure DTC is running and I want through the Comm Conponent -> "Network DTC Access", "Allow Remote Client", "Allow Inbound/Outbound", "Enable TIP" are CHECKED and restarted the Server already. But problem still exists.
Nov 29, 2010 at 05:33 AM Leo
Then I'd check the scripts generated from SQL Compare as noted in the link below. It's possible that the transaction setting is causing the problem.
Nov 29, 2010 at 05:35 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1850
x13

asked: Nov 29, 2010 at 04:51 AM

Seen: 2201 times

Last Updated: Nov 29, 2010 at 04:51 AM