August 3, 2016 at 7:27 am
I have a server running 2 instances of SQL 2008 R2 SP1.
On one instance the Maintenance Plans are working fine on the other they are suspended because SSIS cannot be found.
"Message
Unable to start execution of step 1 (reason: The SSIS subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed."
I have checked the msdb.subsystems table and manually added a row for SSIS (sp_verify_subsystems won't find SSIS) but every time I restart the SQL Agent the SSIS row disappears.
From what I can tell both instances are setup identically with the same user permissions etc. The use which runs the services is in the local admin group on the server.
The above mentioned server is a live box, the test box is also experiencing the same problem although only having one instance installed and running SQL 2008 R2 SP3.
Any suggestions would be much appreciated. Thanks
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply