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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 updating subscriber for transaction replication

Author  Topic 

bchu
Starting Member

2 Posts

Posted - 2006-08-03 : 03:07:55
Dear all,

I have successfully configured transaction replication without updating subscribers. But if use updating subscribers, it was not successful, either queued update or immediate update.

For the queued updating, error message is: ODBC Error:Could not change the Publisher because the subscription has been dropped. Use sp_subscription_cleanup to clean up the triggers.

For the immediate updating, error message is: New transaction cannot enlist in the specified transaction coordinator.

Any response is highly appreciated. Thank you.

bchu

bchu
Starting Member

2 Posts

Posted - 2006-08-04 : 00:33:33
Have some progress, I succeed in two way transactional replication between two servers within the same domain. But I can't do it for two servers residing in two seperate domains, although trust relationship is established between the two.
Go to Top of Page
   

- Advertisement -