4

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 Server 2005 domain1.local

server 1
windows 2003 server
192.168.10.1 connected by vpn
SQL Server 2005
domain1.local

server 2 windows 2003 server 192.168.10.6 connected by vpn SQL Server 2005 domain2.local

server 2
windows 2003 server
192.168.10.6 connected by vpn
SQL Server 2005
domain2.local

When I setup up Replication everything looked fine until I looked at the sync status and it 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 Server Management Studio but just not setup replication?

Yes I can manage each SQL Server in SSMS and we are using merge with snapshot.

migrated from stackoverflow.com Feb 28 '13 at 12:22

This question came from our site for professional and enthusiast programmers.

  • Is it correct that both servers have the same ip address on the vpn, surely they should be different otherwise how does it know how to route the data. – Alain King Feb 28 '13 at 12:34
  • 1
    the sqlserver agent account from the publish/distributor can connect to the subscriber ??? – user20553 Feb 28 '13 at 13:00
  • 3
    If you are getting an error that's already running then it's transactional replication and may already be processing. Check the replication monitor to be sure. – JNK Feb 28 '13 at 13:28
  • Are you able to ping subscriber from publisher and vice versa ? You can also modify replication agent job and add -output c:\repl.log -outputverboselevel 3 for agent step. Stop\ restart your job and check this file for more info. – njvds Feb 28 '13 at 22:06
  • yes i can ping browse and can even configure the server via sql studio but can't setup replication. – Kraig Mar 1 '13 at 8:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.