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
Bạn đang xem 18. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P83 POT