YOUR DEVELOPERS AND CREATED AND SUCCESSFULLY TESTED A PACKAGE. YOU...

18. Your developers and created and successfully tested a package. You have

deployed it to your production server and scheduled the package to run using

the SQL Server Agent. However, when you look at your SQL Server Agent

job history, you see errors on the SQL Server Integration Services Package

step. The errors indicate that the connection to the database failed inside the

package. Which of the following should you check to find the problem

(select all that apply?)

A. Verify that the SQL Server Agent Service account has access to the remote

database

B. Make sure that the SQL Server Agent service is running

C. Make sure that the package was saved with the “Rely on server storage and

roles for access control” protection level

D. Check the package configuration to ensure it is pointing at the right