replication failure because of the setup

• Sthealth

  SSC Enthusiast

  Points: 115

  More actions

  June 28, 2003 at 8:04 pm

  #159340

  I received this message when im setting up a replication at sql server 2000

  "Because SQL Server Agent on GEORIG-KJDFR\VsDotNet uses system account. SQL Server replication between server will fail. To use Replication between server, select another server to be the distributor for GEORIGKJDFR\VsDotNEt"

  any help with this ??

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  June 28, 2003 at 8:06 pm

  #463577

  Try running agent under a domain account instead.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter