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!

  • The SQLServerAgent and the MS SQL Server itself, runs on your NT as a 'service'.

    A service sometimes requires a NT ACCOUNT to run properly (not a SQL account) because it needs system resources available in the operating system and the network.

    Create and use an specific NT Account and ensure it is included in the built in Administrators group.

    ps: be patience, replication requires reads and re-reads

    quote:


    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!


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

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