Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
datawench
Starting Member
1 Post |
 Posted - 2007-04-04 : 09:48:31
|
| i am just beginning to learn how to set up a replication job between a local and a remote database.when i start up the wizard on the local server, i'm told that the startup account for the server agent has to be something other than the system (sa?) account. of course, a couple of standard jobs are already run by this agent... the "db maintenance plan" (backups), etc. now, i assume that any account i assign the server agent to has to have certain conditions met, so that those jobs will continue to run unimpeded. what are they? do i need to set up specific permissions per database on the server, or is there some global feature which, when assigned to the newly created account, will let it run those jobs, as well as let me add these new replication jobs?i've searched the forum on this topic, and think i've assembled half an answer. if anyone can provide me with something more concise, i would be very grateful. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-04-04 : 14:27:17
|
| right-click sql agent, go to properties, connection.change service account to valid domain account with permissions on all objects u need it to access. need to stop/start service for change to take effectprobably it says "Local System" and not "system" account (not sa) |
 |
|
|
|
|
|
|
|
changing the server agent account