none
Replication Problem sql 2005 over openvpn

    Question

  • 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

    I have cleared jobs in the server agent as well just to make sure but still
    nothing <o:p></o:p>

    Could this
    be something to do with authentication between two non trusted domains as I can
    browse and even control each sql server via SQL studio but just not setup
    replication?<o:p></o:p>


    Thursday, February 28, 2013 11:12 AM

All replies