Re: Access Denied when starting Log Reader
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Tue, 21 Mar 2006 22:50:24 -0500
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 SQLMonster.com" <u10790@uwe> wrote in message
news:5d9a8c1242685@xxxxxx
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
.
- References:
- Access Denied when starting Log Reader
- From: fnadal via SQLMonster.com
- Access Denied when starting Log Reader
- Prev by Date: Re: sql server2005 replication stops after a period of time
- Next by Date: Re: SQL Licence for Replication
- Previous by thread: Access Denied when starting Log Reader
- Next by thread: Re: Access Denied when starting Log Reader
- Index(es):
Relevant Pages
|
