Replication Problem sql 2005 over openvpn

Question

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

I have cleared jobs in the server agent as well just to make sure but still
nothing <o:p></o:p>

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?<o:p></o:p>

Answer 1

Stop the job, and then either start it in the jobs folder, or from the command line. Do you still get the message?

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

Hi adamfinch,

Any progress?

Use SQL Authentication between non trusted domains is OK.

Please refer to troubleshoot Replication: http://msdn.microsoft.com/en-US/library/ms151756(v=sql.105).aspx.

Thanks.

---

Maggie Luo
TechNet Community Support