Question

Locked

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:
PKKHIWS1007

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.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums