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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-09-04 : 06:24:09
|
| hi all,i'm trying to create a publisher.i've sys3 server.i'm using the sys3 for replication. there i've jugor and jugor1 databases.my interest is what ever changes done on jugor, the same should be automatically reflected in jugor1 also.now while i'm trying to create a publisher, the error is like this..."server agent on 'sys3' currently uses the system account, which causes replication between servers to fail.in the following dialog box, specify another account for the service startup account"i've full rights like create or drop.....then how could i proceed....VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-04 : 12:39:00
|
| You need to modify the SQL Server service account so that it doesn't use Local System Account. Preferrably, you should use a domain account that has local admin privileges on the sys3 server but doesn't have domain admin privileges.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
replication error