SQL 2005 SP3 - Unable to Edit Maintenance Plans

When trying to open or modify a task within an existing maintenace plan, an error is displayed advising that the task is not registered on this computer. The tasks include backing up a DB, Cleanup tasks and executing a sql statement and the same message is displayed for each.

I have attached a document showing the error. SQL_ERROR
klwnAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
sorry, not really.
the repair process is in the setup application, where you can choose to "repair" the installation ...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
klwnAuthor Commented:
Hi - I have checked the configuration manager and Integration Services has a running status at present. Consequently when I open BIDS and try and create a new Integration Services project a receive an error message which I have attached. Do you suggest I still go ahead with the suggestion previously mentioned? Many thanks

Dax
BIDS-Error.JPG
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
well, I would go ahead and issue a REPAIR of your installation. looks like some dll are missing/deleted/tempered ...
0
 
klwnAuthor Commented:
Hi - Do you have any documentation or steps you can provide for this?

Many thanks

Dax
0
 
klwnAuthor Commented:
Hi - As per my previous comment, do you have any further details you're able to provide?

Many thanks

Dax
0
 
klwnAuthor Commented:
Many thanks for your help with this
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.