Warning! Audit Deprecated
Information
Level 1, Not Scorable
Create dedicated user accounts specifically for proxies, and only use these proxy user accounts for running job steps.
A SQL Server Agent proxy defines the security context for a job step. A proxy provides SQL Server Agent with access to the security
credentials for a Microsoft Windows user. Each proxy can be associated with one or more subsystems. A job step that uses the proxy can
access the specified subsystems by using the security context of the windows user. Before SQL Server agent runs a job step that uses a
proxy, SQL Server Agent impersonates the credential defined in the proxy and then runs the job step by using that security context.
Review the domain privileges of the SQL Server agent service. Make revisions for implementing SQL Agent proxy accounts as necessary. These
permissions may be viewed in Active Directory.
ref. https://benchmarks.cisecurity.org/tools2/sqlserver/CIS_Microsoft_SQL_Server_2005_Benchmark_v2.0.0.pdf, pg 32.
Note: Nessus has not performed this query, and this check is only provided for informational purposes.