The process could not connect to Distributor

• kraig.godden

  SSC Enthusiast

  Points: 181

  More actions

  February 27, 2013 at 3:29 am

  #394269

  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