To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here
When I try to set up replication on my local box, I receive the error - 'SQLServer Agent uses the System Account, which causes replication between the server to fail'.
Why does this happen and would any posters know how I can overcome this
Bianca,
When using replication, the SQL Agent must have rights on all servers involved. The local system account can only access the local server. You should run your SQL services using a domain account that has rights on both servers.