Minimum rights for SQL Agent

From: Bruce Rhoades (bruce.rhoades_at_gdsinc.com)
Date: 02/25/04 

Date: Tue, 24 Feb 2004 20:37:14 -0500

Hi,
Here is a problem:
SQL 2000 servers on Win 2000 servers in NT4 Domain
Security restrictions exclude Everyone group from all the shares and
registries.
The SQL agent and SQL Server service accounts should NOT be Local or Domain
Administrative privileges.

What are the minimum rights and registry access required for these accounts
in order to operate?

Any help is greatly appreciated.

Regards,
JD

Relevant Pages

  • Re: Is possible to import registered SQL Servers to another Enterp
    ... I've sussed thats there's 2 seperate sets of entries for server regs in Ent ... Server\80\Tools\SQLEW\Registered Servers X ... HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL ... But I need to copy remote registries and store it ...
    (microsoft.public.sqlserver.server)
  • Re: Is possible to import registered SQL Servers to another Enterprise Manager
    ... HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL ... Deleted servers and imported that file. ... But I need to copy remote registries and store it ... I tried exporting from the registry ...
    (microsoft.public.sqlserver.server)
  • Re: sql 2005 active/passive cluster options
    ... that is storing data on a seperate SQL 2005 Standard box. ... SQL server had an hardware fault causing application downtime for ... their product is an active/passive sql cluster. ... terms of active/passive failover I need two identical servers (since ...
    (microsoft.public.sqlserver.clustering)
  • RE: permissions compatible with pre-Win2000 servers
    ... Based on your reply, the NT machine which running SQL 7 is not a PDC, BDC, ... With regards to the anonymouse connection to SQL, ... >Our concern is for our NT4 servers that are dedicated to running SQL7 ...
    (microsoft.public.windows.server.migration)
  • Re: Performance Monitor / Database Storage using ODBC
    ... This solution would be just working temporarily (a few servers), ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)