SQL Server 2000 Replication Problem

By sam.scorpio ·
Dear Concern,

I am using SQL Server 2000 and need to replicate heavy running databases to my secondary server which is at DRP location on 4MB WAN link.

I have configured Snapshot Replication and I am running the distributor where the publication is. I receive error in push subscription that

Subscriptions were created successfully at the following Subscribers:

SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT' on server 'PKKHIWS1003'.

5 - (Access is denied)

SQL Server Enterprise Manager could not start the Distribution Agent.

Error 14262: The specified @job_id ('00000000-0000-0000-0000-000000000000') does not exist.

I am unable to understand that why it is saying SQL Server agent not starting.

I have checked on SQL Server Service Manager it is running.

I will highly appreciate if your please help me out.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums