Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 studio but just not setup replication?

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

share|improve this question
    
FYI, it is SQL Server 2005. –  dezso Feb 28 '13 at 12:27
    
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
    
the sqlserver agent account from the publish/distributor can connect to the subscriber ??? –  user20553 Feb 28 '13 at 13:00
2  
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
add comment

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

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

1 Answer

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.

share|improve this answer
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.