configuring server as distributor

  • I am trying to configure my sql server as a publisher/distributor to create transactional Replication. Every time I do so, I get an error message that says 'SQL Server Agent on <server> currently uses the system account, which causes replication between servers to fail. In the following dialog box, specify another account for the service startup account.'

    When I click ok and it takes me to the ensuing dialog box, my only other option is "This Account' which has a name 'LocalSystem' and a blocked-out password. If I select that, click on apply, and then ok I get taken right back to where I was.

    Please tell any idea, i can configure.

    Thanks

  • Have you tried seting this login up with a domain account that has access to both servers?

  • try to logon as sa and enter your password do not use local system if it will not work click the last button i think it is the connection use sa and password for sa.

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

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