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 have cleared jobs in the server agent as well as restarted the service.
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?
I can't seem to locate what the problem is any help would be much appreciated.