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
 SQL Server Administration (2000)
 REPLICATION - TRANSACTIONAL

Author  Topic 

debug
Starting Member

29 Posts

Posted - 2003-10-23 : 10:10:42
HI,

Please help me as I am facing a problem setting up Transactional Replication (Immediate Updating Subscribers).

The problem is that the Publisher server is not able to indentify the state of the MS DTC service of the other server which is on another domain but is trusted by our domain.

The state is being displayed as 'unknown'.

That is why I am not able to push the publication to the Subscriber.

Please suggest.

Regards,
Deepak Uniyal

DU

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-23 : 12:34:29
So is the MS DTC service started on the other machine? SQL Server gives up trying after 30 seconds when checking for the state. Is your network slow enough to cause this?

Tara
Go to Top of Page

debug
Starting Member

29 Posts

Posted - 2003-10-24 : 01:59:33
Hi Tara,

Thanks for the prompt response as ever.

We have plenty bandwidth available with us and the ping response to the subscriber from publisher is below 30ms.

Please suggest.

Regards,
Deepak

DU
Go to Top of Page

debug
Starting Member

29 Posts

Posted - 2003-10-24 : 02:00:28
The MS DTC service is running on the subscriber.

DU
Go to Top of Page
   

- Advertisement -