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

Configure the SQL Server Agent by www.varindersandhu.in

Right click My Computer -> Manage… -> Choose from the tree at the left: “Services and Applications” -> “Services”

Configure the SQL Server Agent by www.varindersandhu.in

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.

Configure the SQL Server Agent by www.varindersandhu.in

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.

Reference URL
http://varindersandhu.in/2011/08/12/sql-server-how-to-setup-sql-server-replication/

Share on Facebook

Post on X

Follow us

Save