sql server replication: distributor error -- sql server replication

distributor error

jullie
9/12/2007 9:24:01 PM

sql server replication: hi all,

i got this error when trying to set up publisher and distributor.

`Because SQL server agent on 'SERVER1' uses the system account, SQL Server
replication between servers will fail. To use the replication between
servers, select another server to be the Distributor for 'SERVER1'.

i only have 2 servers, SERVER1 for publisher and distributor and SERVER2 for
subscriber.

Re: distributor error

Hilary Cotter
9/13/2007 12:00:00 AM

Have your SQL Server agent run under a local administrator account and use a
push subscription.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]