You work as a database administrator at ABC.com. ABC.com makes use of SQL Server 2000
instance.
A current specific job is configured to retrieve a file remotely from a shared network folder via a
CMDExec step. The use of the LocalSystem account has been configured for the SQL Server
Agent service.
You receive an instruction to upgrade the current SQL Server instance to SQL Server 2008 R2.
Subsequent to the upgrade, you notice that the job step is unable to finish its process.
It is imperative that this issue be rectified.
Which of the following actions should you take?
A.
You should consider reconfiguring the job step to make use of a remote System account.
B.
You should consider reconfiguring the job step to make use of a Local Service account.
C.
You should consider reconfiguring the job step to make use of a proxy account.
D.
You should consider reconfiguring the job step to make use of a Domain account.
Explanation: