none
Sql 2005 The process could not connect to Distributor

    Question

  • 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
    Wednesday, February 27, 2013 11:13 AM

All replies