SQL Server Replication – Configure the SQL Server Agent – Part 1 of 4
Once you are going setup SQL Server Replication configures the SQL Server Agent as:
Make Sure SQL Server Agent is running
Right click My Computer -> Manage… -> Choose from the tree at the left: “Services and Applications” -> “Services”
By default the SQL Server Agent runs under the local System account, but for SQL Server Replication to work this must be changed to a specific created user account that has all the necessary rights to run as a service.
Preferably, the user that is assigned to the Agent is a domain user that is known both at the client systems and the publishing database server.
By default the main registration within SQL Server enterprise manager is called “local”. On the main publishing server this must be changed to a qualified address or name to have SQL Server replication working as above.