Scheduling SSIS packages from SQL Agent can produce the following error on a new installation of SQL Server:
“Connecting to the Integration Services service on the computer “…” failed with the following error: "Access is denied". By default only administrators have access to the Integration Services service. On Windows Vista and later the process must be running with administrative privileges in order to connect to the Integration Services service.”
The following article describes the fix (adding permissions for the SQL Agent service to SSIS via DCOM)
No comments:
Post a Comment