distribution agent failed in transactional replication

[cyno]

Hello All

I have configured transactional replication within same domain.The publication and subscription were created successfully and and a snapshot is generated.But for some reason when i run the distribution agent its failing. here is error message iam getting on the distribution agent

The process could not connect to subscriber.
General network error. Check your network documentation.

Did anyone come accross this situation. I am able to ping the destination server.Any help would be appreciated.

Cyno

 

[Catadmin]

Is the replication process working through a Trusted connection? Regardless of the machines being in the same domain, unTrusted connections can be created.

Also, are they both using the same SQL Server login/pwd? The subscriber might be using a login that doesn't have the necessary permissions (Log in as a Service, part of the local Administrators Group, etc.).



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[cyno]

Cat - The startup service account for both the servers are different.But the login do exist on the other server with sysadmin priv.

Cyno

 

[Catadmin]

I can't be sure, but I recently did research via many books & Google on replication. I thought I saw something that said the logins the servers used had to be the same.

Check Books Online first. Then Google your error message. Someone may have previously posted to this or another forum regarding it.

Anyone else have thoughts?



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[cyno]

No we have servers configured for replication using different logins. Anyways i will dig into it... Thanks for you help.


Cyno