How to setup replication using MS SQL 2005
Posted on 2009-04-15
I am currently trying to replicate from an internal server to web server sitting in the dmz of a Cisco firewall. The publication is setup and appears to work fine. I setup the subscriber on the web server and everything looks fine.
When viewing the synchronization status, there is an error "The process could not connect to the distributor 'Server Name' "
When I click on View Job History I get "The execute permission was denied on the object 'sp_help_job', database 'msdb', schema 'dbo'.