Anmelden
 
HomeLibraryDownloadsSupportWebcasts & EventsCommunityForenBlogs
Ressourcen für IT-Professionals >
> 
> 
Sql 2005 The process could not connect to Distributor

Frage Sql 2005 The process could not connect to Distributor

  • Mittwoch, 27. Februar 2013 11:13
     
     
    Anmelden
    0
    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
     

Alle Antworten