bmaitdepartment
asked on
How to setup replication using MS SQL 2005
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'.
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'.
ASKER
Still getting the same error
ASKER
I am still at a loss on this one, any one have any more ideas?
whoops...I think it is because you dont' have permissions to view the history. Do you have sa access? If not, have someone give your username the permissions I discussed above.
ASKER
in the job history it now says login failed for 'username', where does this username have to be in order to work, i have it everywhere i can think of
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
which permissions would that be?
right click my computer, then go to manage. Find services, and then the SQLAgent service. Make sure the account that runs that service is able to log into both machines...should be a domain account.
ASKER
i have 2000 and 2005 installed on that server, i only see the agent for 2000 running, is that an issue or just pay attention to the 2000 account?
pay attention to everything that is using replication.
ASKER
the account running sqlagent can't log on to the server with the subscriber, they are on different domains
Can both machines get to the distributor machine?
ASKER
The publisher is the distributor. I can connect from the subscriber to the distributor/publisher.
is there a trust between the two domains?
ASKER
In response to your post about having the necessary permissions on the SQL server Agent:
"right click my computer, then go to manage. Find services, and then the SQLAgent service. Make sure the account that runs that service is able to log into both machines...should be a domain account."
I can't make the account have access to both machines if they are not in the same domain. I have the publisher/distributor server inside the domain and the other is in the dmz (outside the domain).
"right click my computer, then go to manage. Find services, and then the SQLAgent service. Make sure the account that runs that service is able to log into both machines...should be a domain account."
I can't make the account have access to both machines if they are not in the same domain. I have the publisher/distributor server inside the domain and the other is in the dmz (outside the domain).
ASKER
The DMZ server is not in a domain. It is a stand alone server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
use msdg
grant exec on sp_help_job to accountrunningsqlajgent