Groups | Blog | Home
all groups > sql server replication > june 2007 >

sql server replication : Replication implementation hurdles.


Awais Nazim
6/26/2007 7:44:01 AM
Hi,

We have a product that configures on SQL 2000 and also configures the
replication. We are in the process of doing R&D on SQL 2005.
Following are my machine specifications
OS Type : Windows 2000 Server (SP4)
SQL Server : SQL 2005

When i try to create a publisher and a subscriber, on the subscriber
machine, Replication Job gives an error message 'Agent message code 20084.
The process could not connect to Distributor '[Machine Name]'.'

I have tried using SQL Server accounts and Windows Authentication accounts,
but both are giving same error message.

Any ideas?

Thanks
Ahmed Awais
SSE Title Developments
Paul Ibison
6/26/2007 10:01:04 AM
Can you connect using SSMS from the subscriber to the publisher? Also, has
the servername changed recently ie what does select @@servername return on
the distributor?
Paul Ibison
Awais Nazim
6/27/2007 1:12:01 AM
Yes i can connect publisher from subscriber using SSMS and server name is not
changed. Query return the same servername which i am using.

[quoted text, click to view]
Paul Ibison
6/27/2007 1:34:03 AM
OK - on the distribution agent can you enable logging and we'll see if there
is any more info we can get: http://support.microsoft.com/?id=312292.
Also, are you replicating across non-trusted networks, and can you ping the
distributor from the subscriber?
Cheers,
Paul Ibison
AddThis Social Bookmark Button