Results 1 to 2 of 2

Thread: Replication - SQLServer Agent uses System Account

  1. 02-03-2003, 02:46 AM #1
    Bianca_J
    Bianca_J is offline Registered User
    Join Date
    Jan 2003
    Posts
    22

    Replication - SQLServer Agent uses System Account

    When I try to set up replication on my local box, I receive the error - 'SQLServer Agent uses the System Account, which causes replication between the server to fail'.

    Why does this happen and would any posters know how I can overcome this

    Thanks,

    Bianca
    Reply With Quote Reply With Quote
  2. 02-03-2003, 09:17 AM #2
    JBane
    JBane is offline Registered User
    Join Date
    Dec 2002
    Posts
    181
    Bianca,
    When using replication, the SQL Agent must have rights on all servers involved. The local system account can only access the local server. You should run your SQL services using a domain account that has rights on both servers.


    Jeff
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules