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