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 |
|
Bobba Buoy
Starting Member
36 Posts |
 Posted - 2003-07-16 : 15:56:47
|
| I am trying to configure my sql server as a publisher/distributor to create Merge Replication. Every time I do so, I get an error message that says 'SQL Server Agent on <server> 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.'When I click ok and it takes me to the ensuing dialog box, my only other option is "This Account' which has a name 'LocalSystem' and a blocked-out password. If I select that, click on apply, and then ok I get taken right back to where I was.Any ideas? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-16 : 16:10:43
|
| Go to Control Panel, then go to Administrative Tools, now open Services. Double click on SQLSERVERAGENT. Go to Log On. Click This Account. In the first field, put in either a domain account that has local administrative privileges or a local account that has administrative privileges (do not use LocalSystem and domain account is recommended). Then for the second and third fields, type in the password. Then click Ok. Now restart the service (right click on it). Then configure replication. You should do this for both SQLSERVERAGENT and MSSQLSERVER services as this is the recommended configuration.Tara |
 |
|
|
Bobba Buoy
Starting Member
36 Posts |
Posted - 2003-07-17 : 08:31:02
|
| Thanks for your help! I have another issue maybe you could help me with:1) I have my publisher/distributor set up for merge replication but I need to create the initial snapshot and I am not sure how to do this?2) I am doing all of this from the Publisher. What do I need to do on the subscriber end? Again, this is a merge publication.I am using this replication as a redundant database so that I can disconnect and take it to a non-connected location. After a 'job' is done I will want to merge the data back. Does this have to be done manually? Do I have to create a push subscription from the subscriber? Or a pull subscription from the publisher? Or do these things not apply with merge publications?Thanks for your help!!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-17 : 12:26:43
|
| I am not that familiar with replication but I was familiar with the error that you were getting.Tara |
|
|
|
|
|
|
Replication Help