You maintain a SQL Server 2008 instance that runs on a computer that hosts several
applications. You configure the SQL Server Agent service to run by using the
SERVER1\AGENT account. You create a job named MailingList that requires a file to be
written to a file server. The job fails to run because it does not have appropriate access to
the file server. You plan to configure the SQL Server Agent service.
You need to perform the configuration such that only the SQL Server Agent service has read
and write access to the file server.
Which account type should you use?
A.
Domain account
B.
Local System account
C.
Local Service account
D.
Network Service account