Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setup Sql Server 2000 for Replication

Status
Not open for further replies.
saw15

saw15

Technical User
Jan 24, 2001
468
US
I am tying to setup replication (merge) on my local pc to test out sql server etc.

Right clicking on Replication, I select Configure Publishing, Subscribers and Distribution.

I then get a message indicating that the system account is being used and will cause replications to fail between servers.

My question is, what should I be using? Should I create a new login under Security and have SqlAgent run under that?

Looking for any type of example or steps to take to setup the user necessary for replication between servers.

Thanks in advance.
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
406
Chriss Miller
C
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
767
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
958
pjw001
pjw001
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
552
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
644
Mike Lewis
Mike Lewis

Part and Inventory Search

Sponsor

Back
Top