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.
