You are the administrator of your company network. Now you’re in charge of a SQL Server 2008 instance which runs on a computer. The computer hosts several applications. You use the SERVER1\AGENT account to configure the SQL Server Agent service to run. You create a job called PostingList. It needs a file to be written toa file server. But since the job doesn’t have right access to the file server, it fails to run. You intend to configure the SQL Server Agent service so that only it has read and write access to the file server. So which account should you use?
A.
You should use domain account
B.
You should use System account
C.
You should use Local Service account
D.
You should use Network Service account