September 16, 2007 at 6:28 pm
Hi Team,
I have been having a problem with running the Maintenance Plans on SQL 2005, Basically the maintenance plans have been failing for some time now and stats the job has been suspended, I have tried changing the SQL Agent credentials with little effect. The SQL 2005 Build is 9.0.1399
The following events occurred in the event log where the last backup was run.
The SQL Server (MSSQLSERVER) service terminated with service-specific error 17058 (0x42A2).
The SQL Server Agent (MSSQLSERVER) service depends on the SQL Server (MSSQLSERVER) service which failed to start because of the following error: The service has returned a service-specific error code.
The following errors occur when we try to create or run a maintenance plan:
Message
[000] Request to run job ConnectWise Maintenance Plan - full backup daily (by Sage) (from User cwdblogin) refused because the job has been suspended
[LOG] Step 1 of job 'ConnectWise Maintenance Plan - full backup daily (by Sage)' (0xF42A3DB8647AE847B2CA5CDE852ECB04) cannot be run because the SSIS subsystem failed to load. The job has been suspended
Has anyone got any ideas on how to resolve this issue
Thanks
Blair
September 16, 2007 at 9:33 pm
Hi Guys,
I worked out that somebody removed the SSIS services from the server.
Thank anyway, love reading the posts
Regards
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply