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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-05 : 08:04:09
|
| Bianca Johanssen writes "When I try to set up replication on my local box, I receive the error - 'SQLServer Agent uses the System Account, which causes replication between the server to fail'.Why does this happen and would any posters know how I can overcome this :)Thanks,Bianca" |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2003-02-05 : 09:25:44
|
| I don't know much about replication (nothing, actually)but you should probably change the Sql Server Agent tostartup as a database account (sa). i don't know why but changing it startup as a db account will probably help.________________________________________________A recent study shows that Southern Germany may have the best beer in the world. |
 |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2003-02-05 : 21:12:13
|
quote:
Bianca Johanssen writes "When I try to set up replication on my local box, I receive the error - 'SQLServer Agent uses the System Account, which causes replication between the server to fail'.Why does this happen and would any posters know how I can overcome this :)Thanks,Bianca"
My personal opinion is that there should be a separate account that has sysadmin rights, not sa. sa should only be used as a dba backdoor. If you're on a network and both servers are on the same domain or if they are on two separate domains that are trusted this account should a network account, not a sql server login. |
|
|
|
|
|
|
Replication - SQLServer Agent uses the System Account