Access Denied when starting Log Reader

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 droptable.com
http://www.droptable.com/Uwe/Forums...ation/200603/1
Right click on the log reader agent and make the job owner sa, then right
click again and restart it.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"fnadal via droptable.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 droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200603/1
|||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 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)
The log reader agent is set to use SA. Still can't access database.
Both the services are using the same domain account.
I'm stumped. Thanks for the help nonetheless.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200603/1
|||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)
|||Hi
I had the same problem. I applied Sp3 in the distributor. It started to
work..
P. Srinivasan MCDBA
Consultant
C-13/1,GF,Tulip Garden, Ardee City,
Sector-52,
Gurgaon-122003
India
Mobile:+91-9810321551
"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)
>
>

Access denied when pushing a new subscriber.

If I select "Continously-Provides minimal latency between when an actions
occurs at the publisher and is propagated to the subscriber" for the agent
schedule when pushing a new subscriber, the wizard throws the following
exception:
" SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT'
on server 'SRV_DESARROLLO'.
5 - (Denied Access)"
Where do I set these permissions?
Thank you.
Regards!
Omar Rojas
Message posted via http://www.droptable.com
Sounds like your SQL Server agent is not started.
Try this
master.dbo.xp_cmdshell 'net start SQLServerAgent'
Hilary Cotter
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
"Omar via droptable.com" <u14595@.uwe> wrote in message
news:55716496f57f8@.uwe...
> If I select "Continously-Provides minimal latency between when an actions
> occurs at the publisher and is propagated to the subscriber" for the agent
> schedule when pushing a new subscriber, the wizard throws the following
> exception:
> " SQL Server Enterprise Manager could not start the service
'SQLSERVERAGENT'
> on server 'SRV_DESARROLLO'.
> 5 - (Denied Access)"
> Where do I set these permissions?
> Thank you.
> Regards!
> Omar Rojas
>
> --
> Message posted via http://www.droptable.com
|||Hillary, seems not to be this since the database in the subscriber server is
well created. Either way I executed what you told me before re-creating the
subscription.
Thank you.
Omar
================================================== ============================
Hilary Cotter wrote:[vbcol=seagreen]
>Sounds like your SQL Server agent is not started.
>Try this
>master.dbo.xp_cmdshell 'net start SQLServerAgent'
>[quoted text clipped - 11 lines]
Message posted via http://www.droptable.com