System Account and Replication

  • When configuring replication, after selecting distributor, a dialog came back with the following:

    SQL Server Agent on "MYSERVER" currently uses the system account, which causes replication between servers to fail. In the following diaglog box, specify another account for the Service startup account.

    I tried going back to use one of the SQL account which was already setup but still couldn't get to work. Please help!

  • Agent needs to run under a domain account and will need disk access permissions. Get that working first, then try again.

    Andy

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply