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
Showing posts with label propagated. Show all posts
Showing posts with label propagated. Show all posts
Saturday, February 11, 2012
Subscribe to:
Posts (Atom)