The process could not connect to Distributor

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » The process could not connect to Distributor

The process could not connect to Distributor

Rate Topic

Display Mode

Topic Options

Author

Message

kraig.godden

Posted Wednesday, February 27, 2013 3:29 AM

Grasshopper

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 »

Permissions