PrepAway - Latest Free Exam Questions & Answers

You need to configure the job step so that it can successfully complete execution

You upgrade an instance of Microsoft SQL Server 2000 to SQL Server 2008.
The SQL Server Agent service is configured to use the LocalSystem account. A job uses a
CMDExec step to access a file located on a remote network share.
After the upgrade, the job step fails to complete execution.
You need to configure the job step so that it can successfully complete execution.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Configure a certificate.

B.
Configure the job step to use a proxy account.

C.
Configure the SQL Server Agent service to use a local Windows account.

D.
Configure the SQL Server Agent service to use the NetworkService account.


Leave a Reply