"fnadal via SQLMonster.com" <u10790@uwe> wrote in message
news:5d9a8c1242685@uwe...
> I've been trying to set up the publisher for transactional replication.
>
> The distribution server is sp2 the subscriber is sp3.
>
> I have set up replication on Server1 to be its own distributor.
>
> However I have been recieving errors such as this below:
>
> SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT'
> on
> server 'Server1'. 5 - (Access is denied)
>
> and
>
> Execute permission denied on object 'sp_mshelp_logreader_agentid'.
>
> or
>
> The could not access database db1 on Server1.
>
> I also checked the services msssqlserver and sqlserveragent on the other
> server and the 'log on as' is the same on both which has admin rights.
>
> I'm really stumped, I don't know what to check next.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200603/1

Paul Ibison wrote:
>Please make sure that SQL Server Agent and the SQL Server Service both use
>the same domain account (in local admins).
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:eN1n8ibTGHA.4956@TK2MSFTNGP09.phx.gbl...
> Is the domain account a local administrator?
> Also, can you start the sql server agent service manually?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>