Permission to start/stop logreader and distribution agent

From: Armin (arminmu_at_lsinter.net)
Date: 01/27/04 

Date: Tue, 27 Jan 2004 06:24:35 -0800

Hi all!

SQL Server 7.0, NT 4.0
I have distribuition server, whose only role is to be a
distributor, there are no user databases on it. I want to
create login on that server, a login which can only check
the status of logreaders and distribution agents, and to
start or stop them, everyrhing in EM Console - Replication
Monitor. Some users will be able to register Distributor
server in their EM Console using this login.

Does anybody have an idea how to do this?

TIA!

Armin

Relevant Pages

  • Re: SQL Server and Agent Accounts
    ... authority\Network service" isn't a member of SQL server sysadmin. ... Distributor, the user need to be a member of the sysadmin fixed server ... Replication implements login security by requiring a user to have a valid ... On the Microsoft Windows 98 operating system, SQL Server Agent and the ...
    (microsoft.public.sqlserver.replication)
  • Re: Change distribution server
    ... I now have the distributor and subscriber setup on SQL2005. ... SQL2005 SQL Agent is started under Local System Account if that matters. ... To get the SQL 2000 server to use the SQL 2005 distributor, ... subscriptions before doing this because the warning message seems pretty ...
    (microsoft.public.sqlserver.replication)
  • Re: Compromise of the nobody account?
    ... Find a real news server. ... or unknown security hole. ... If the distributor hasn't set that configuration by ... Linux are likely to be more competent than typical Windows users, ...
    (comp.security.unix)
  • Re: Inactive Publisher??????
    ... MSdistpublishers table in msdb on the distributor server shows the ... Shouldn't the publisher server have is_publisher=1? ... I then imported data from the publisher to the subscriber so that the ...
    (microsoft.public.sqlserver.replication)
  • Re: Web Suscription of a SQL Server 2005 CE client to a SS 2005 Standa
    ... sub.PublisherName = publisherName; ... Server running SQL Server 2005 containing the publications. ... the publihser and the distributor are on ... For Each Paramet In ErrRec.Params ...
    (microsoft.public.sqlserver.replication)