Re: SQL Server and Agent Accounts

Hello,

For the first question, I suggest that you refer to the information in SQL
server Books Online:

"Security Considerations" topic:

---------------------------------------------

The SQL Server Agent service (SQLServerAgent) at the client should not use
the LocalSystem account. It needs to use a standard domain account. The
SQLAgent account is the security context under which the Snapshot Agent,
Merge Agent, and Distribution Agent are running by default.

....

You must be a SQL Server 2000 system administrator to enable the server for
replication. After replication is enabled, you do not need to be a SQL
Server 2000 system administrator to set up publications and subscriptions,
or to invoke or schedule the replication agents. You must be in the
db_owner role to create publications. Anyone who is added to the
publication access list (PAL) can create pull subscriptions to that
publication (but only to that publication).

---------------------------------------------

For the second question, refer to the "Agent Login Security" topic in SQL
server Books Online. For more information, refer to the following topics:

"Connecting to the Distributor"
"Replication Security"

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • Re: Borland is neglecting Delphi for Win32 badly
    ... Today in SQL ... Server 2000 you can write server extensions as COM objects and call them via ... SQLCLR allows CLR ... The security benefits are also tremendous and we could discuss for a long ...
    (borland.public.delphi.non-technical)
  • Re: SQL Server 2000 Replication Agents Credentials
    ... the snapshot agent IS using sql login to connect to the ... The pull distribution agent IS using sql ... Do you know where SQL Server 2000 saves the sql ...
    (microsoft.public.sqlserver.replication)
  • RE: Replication Error
    ... account that the SQL Agent runs under. ... When I setup replication two jobs are setup within sql server server. ... step of each job (Snapshot Agent startup message, ...
    (microsoft.public.sqlserver.replication)
  • Re: Trend Micro SMB v3.0 Installation Nightmares
    ... Note, I was not running v2.0, this was a new trend install. ... I have WSUS running on the same server. ... Console session expired any time trying to configure the messaging agent ... Update Now from clients fails because it cannot find the security server ...
    (microsoft.public.windows.server.sbs)
  • Trend Micro SMB v3.0 Installation Nightmares
    ... this was a new trend install. ... - Messaging agent fails/hangs during install ... - Exchange server becomes outdated on status page but won't allow a new ... each component from the security server from the Add/Remove programs. ...
    (microsoft.public.windows.server.sbs)