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 |
|
pontifikas
Starting Member
32 Posts |
 Posted - 2004-09-14 : 04:20:14
|
| Though I'd swear I've seen sth about this before I could not mine it via search.I have a problem.At the very beggining, when setting my server to be both Distributor and Publisher I get an error message that I cannot use the system account. Some things I did almost proved disasterus.I'm a novice user and dont want to do sth stupid again.How do I overcome this obstacle?Thanks in advance. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-14 : 04:24:28
|
i suggest you post the actual error message for better tips? |
 |
|
|
pontifikas
Starting Member
32 Posts |
Posted - 2004-09-15 : 06:13:06
|
| The error is the following:"Sql Server Agent on MyServer currently uses the system account, whch causes replication between servers to fail. In the following dialog box specify another account for the Service startup account."When I go and specify an existing user, either I get errors or not full access to the DB,although I have set full access rights to the user. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-15 : 06:50:35
|
| first check the following:1. the account used to start up the sql services where the publisher is should be a domain account and member of the local admin group (to share resources), repeat this with subscriber2. if #1 did not fix the problem... go to menu\tools\replication>configure publishing, subscribers,distribution, etc>subscribers tab>change the password of the subscriber (one which has sysadmin privilege) -- this is on publisher side |
|
|
|
|
|
|
Setting Distributor-Publisher