Groups | Blog | Home
all groups > sql server replication > may 2006 >

sql server replication : MSDTC Issue


Jonas Larsen
5/31/2006 11:03:01 PM
Guys

I have an updateable transactional Replication. It works fine from Publisher
to Subscriber but when I try to update a table on the Subscriber I get the
following error:

Server: Msg 8501, Level 16, State 1, Line 5
MSDTC on server 'SERVERNAME\INSTANCE' is unavailable.
Server: Msg 7391, Level 16, State 1, Line 5
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d01c].


My Publisher is a Win2000 with SQL2000+SP4 and my subscriber is a Win2003
with SQL2000+SP4. The Publisher database is on an instance ( Used to be an
old cluster node however SQL was reinstalled but due to all the Production
systems the instance remained).

Thanks.

Regards
Jonas Larsen
6/1/2006 2:01:02 AM
I have checked that and thats ok.

I think the issue is with the Publisher as I have used the subscriber as
such in a previous test setup with another 2003 server.

[quoted text, click to view]
Jonas Larsen
6/1/2006 4:21:01 AM
No firewall....

[quoted text, click to view]
Hilary Cotter
6/1/2006 6:14:14 AM
Is there a firewall between these two boxes? This could explain your
problem.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Paul Ibison
6/1/2006 9:46:53 AM
Jonas,
on Windows 2003 and Windows XP (sp2) the MSDTC is disabled by default (see
http://support.microsoft.com/kb/839279). Please check this first.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Paul Ibison
6/1/2006 10:07:46 AM
Jonas,
sounds obvious, but please check that MSDTC is up and running on the
publisher. Assuming it is, there is a simple troubleshooting guide for these
issues: http://support.microsoft.com/kb/306212/en-us
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com



Paul Ibison
6/1/2006 1:14:37 PM
In that case, check for name resolution issues - can you ping the publisher
from the subscriber? Can you establish a connection in EM/SSMS on the
subscriber to the publisher?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Jonas Larsen
6/1/2006 3:24:02 PM
Yeah it pings fine, connects fine with EM & QA.
But cannot run a distributed query tho. but normal is fine.

[quoted text, click to view]
Paul Ibison
6/2/2006 12:00:00 AM
I'd check that the steps in (1) and (2) of this article have been done:
http://support.microsoft.com/kb/839279. If this is all set up correctly then
I'd open a support case as you will have done all basic troubleshooting.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com



AddThis Social Bookmark Button