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 |
|
Ex
Posting Yak Master
166 Posts |
 Posted - 2005-04-21 : 01:53:08
|
| Hey all,i am new to replication and not to sure about this.I get this error message when i try to setup replication through the wizardon the Make 'myHost' its own Distributor in the Replication -> configure publishing, subscribers, and distribution wizardi get the errorSQL Server Agent on 'myHost' current uses the system account, which causes replicaiton beween servers to fail. i have tried changing sql server to windows login but it got all buggared upcan anyone tell me how to get this replication to work or direct me to somewhere that step by step shows how to do it?ta any help would be appricated :) |
|
|
Ex
Posting Yak Master
166 Posts |
Posted - 2005-04-21 : 01:56:21
|
| quick little add,i am using my sa account to login should i be running the sql server agent and sql server with windows logins for replication to work?i.e cant use sa (system account?) |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-21 : 02:04:28
|
if subscriber is a different server from publisher then replication will failsql services must run using a domain account, the domain account should be sa in your server for replication to workset this up first then if you encounter a problem, post it here and we'll try our best to help youdon't forget to restart the services when you change the service account  --------------------keeping it simple... |
|
|
|
Ex
Posting Yak Master
166 Posts |
Posted - 2005-04-21 : 19:11:44
|
| i will refresh this post :)the domain accoutn should be sa in your server.Withouth sounding like a total idiot do you mean setting up a windows login account with sa? or setting up sql server to only use windows authentication?(if so does both publisher and subscriber need same account details, or just both admin privleges) not to sure how to set this up any direction would be appricate :) sorry for the stupid questions |
|
|
|
Ex
Posting Yak Master
166 Posts |
Posted - 2005-04-21 : 21:57:56
|
| sorry think i worked it out reading up on some tutorials.I was running sql server under the localAccount and i should run it under a admin account? not sure if the local account is right but quite sure that is the problem thanks |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-22 : 01:03:38
|
quote:
Originally posted by Ex
sorry think i worked it out reading up on some tutorials.I was running sql server under the localAccount and i should run it under a admin account? not sure if the local account is right but quite sure that is the problem thanks
1. the domain account should be a member of the local admin2. add this account to the server logins with SA privileges3. check/change if sql services are using the domain account instead of the local system account 4. restart the sql services***it doesn't matter if you're using windows authentication or mixed modefor replication :check if replication is encountering any error by restarting the distribution agentthen post the error here so we can isolate the problem HTH--------------------keeping it simple... |
|
|
|
|
|
|
replication