|
Hi, I tried to synchronize the Database between 2 Servers using Red Gate Compare, I am getting the following error.
Anybody got that error before? Do you know how to resolve that issue? Thanks.
(comments are locked)
|
|
This came up once before here on ASK. You might want to look here and see if you're dealing with a related issue. 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 '10 at 05:43 AM
Leo
Excellent. And that's a good blog post. I'll add it to the stack.
Nov 29 '10 at 06:14 AM
Grant Fritchey ♦♦
(comments are locked)
|
|
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. 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 '10 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 '10 at 05:35 AM
Grant Fritchey ♦♦
(comments are locked)
|
