Transactional Replication SQL 2005 Cannot connect to the subscriber

I have configured transactional replication with Publisher, distributor
and subscriber on different servers. Publisher and Distributor are
running on sql 2000 SP4 and the subscriber is running on sql 2005.

When I reintialize the subscription, the distribution agent errors out
saying "cannot connect to the subscriber".

The agents are running on the distributor, and assuming using the same
ID that the sql agent is running under. I have granted that ID
db_owner rights on the subscriber database on the subscriber.

What am I missing? WHat ID does the distributor or the agents use to
connect to the subscriber?

Any help is appreciated.

Thanks
Geetha

.

Relevant Pages

  • Re: Snapshot or merge replcation propagation problem
    ... Your publisher is unable to connect to your subscriber. ... In SQL 2000 to make this change expand the replication folder, ... merge agents folder, locate your merge agent, right click on it select agent ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • RE: Web Synchronization: Could not connect to distributor
    ... Note that the error says "could not connect to the Distributor". ... I have tried many times to create a new agent profile with verbose logging ... Subscriber #9 is working now after deleting and re-creating the database ...
    (microsoft.public.sqlserver.replication)
  • Merge SQL 7 to 2000 problem
    ... a SQL 7 publisher/distributor and a SQL 2000 subscriber ... the agent ... Disconnecting from Publisher 'chrs4' ...
    (microsoft.public.sqlserver.replication)
  • Server SQLTEST1 is not prepared to run the offloaded agent
    ... Right-clicking on the distribution agent offers an option, ... Box comes up that says "Subscriber must be prepared ..." ... Server 'SQLTEST1" is not prepared to run the offloaded agent. ... The agent failed to connect to the Distributor due to the ...
    (microsoft.public.sqlserver.replication)
  • Re: Transactional Replication SQL 2005 Cannot connect to the subscriber
    ... I turned on the logging level for the agent. ... Connecting to Distributor 'STLDBA-STG1.Dist_MSNWSSQLSTG1' ... Subscriber security mode: 0, login name: sa. ... Microsoft SQL Server Distribution Agent 8.00.2039 ...
    (microsoft.public.sqlserver.replication)