Transactional Replication problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Transactional Replication problem

Author

Topic

hdv212
Posting Yak Master

140 Posts

Posted - 2009-09-04 : 14:18:44

Hi
i've created a new transactional replication with updatable subcription, now when i create new subscription and followed wizard and click finish to create a subscription, i go this warning :

Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication.

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "REPLLINK_MYLAPTOP692949684_NORTHWIND-814528215_NORTHWINDT1316245127_NORTHWINDT1316245127" was unable to begin a distributed transaction.
Changed database context to 'NorthwindTransUpd'.
OLE DB provider "SQLNCLI" for linked server "REPLLINK_MYLAPTOP692949684_NORTHWIND-814528215_NORTHWINDT1316245127_NORTHWINDT1316245127" returned message "The partner transaction manager has disabled its support for remote/network transactions.". (Microsoft SQL Server, Error: 7391)

1. my publisher os is xp sp2
2. my subscripber os that i want to create is win 2003 sp2
3. both have sql server 2005 (without any service pack)
4. the Distributed Transaction Coordinator has been startd in both machines
5. both sql servers has been configured with allow remote connection
6. both msdtc has been started and i follow this link for both machines : http://support.microsoft.com/?kbid=873160
7. also i follow this link to configure my firewall in my publisher machine : http://support.microsoft.com/kb/816701

but still i got the above error.
can anybody help me to workaround the problem ?
thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-09-04 : 15:31:02

Why don't you have any service packs installed on either SQL Server? There are literally thounsands of things that have been fixed up to the latest build.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

hdv212
Posting Yak Master

140 Posts

Posted - 2009-09-04 : 18:41:48

Thanks tkizer
but before this, i do it without any error! but now i can't do this. i think it's not related to service pack. what about u ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-09-05 : 21:10:41

How can you make that assumption?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources