Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

The process could not connect to Distributor Expand / Collapse
Posted Wednesday, February 27, 2013 3:29 AM


Group: General Forum Members
Last Login: Thursday, February 28, 2013 3:46 AM
Points: 17, Visits: 44
Hi Guys

I am in the process of creating replication between 2 remote servers, server 1 is the distributor and publisher and server 2 is the subscription

server 1
windows 2003 server connected by vpn
SQL 2005

server 2
windows 2003 server connected by vpn
SQL 2005

when i setup up the replication all looked fine until i looked at the sync status and is said

The Agent could not be started

an exception occurred while executing a transact-sql statement or batch

sqlserveragent error request to run job
server1-username blah blah blah

from user sa refused because the job is already running from a request by user sa changed database context to technical error 22022

I can't seem to locate what the problem is any help would be much appreciated

Post #1424437
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse