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 |
|
bobanjayan
Yak Posting Veteran
67 Posts |
 Posted - 2004-05-20 : 09:17:37
|
| Dear friends,Please help me.I am trying to replicate my production database with a database in other location.I created a user "Admin" for replication in both the database server with same password. And include into Administrators group. Set "Log on as a service" permission to that (in both servers).I started "Configure Publishing and Distribution Wizard", I got the message "SQL Agent on 'SERVER1' currently uses the system account, which causes replication between server to fail. In the following dialog box, specify another account for the Service startupaccount."I changed the "LocalSystem" account to "Admin". |
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-05-20 : 09:22:50
|
| ****Sorry, pressed the Enter key to come to the next line...posted.****Topic Cont....It had given the error --"The new service startup account name you have supplied is invalid or does not exist. "What extra privilege should I give to this user ?Anticipating for your answer. |
 |
|
|
|
|
|
Service startup Account for replication.