Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
192.168.10.1 connected by vpn
SQL 2005
domain1.local

server 2
windows 2003 server
192.168.10.1 connected by vpn
SQL 2005
domain2.local

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

thanks

http://www.go-train.co.uk


http://www.go-train.co.uk
Post #1424437
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse