Craig Rutherford
asked on
Can't create Maintenance Plan on SQL 2008 - Invalid class string error
Good Morning.
I'm experiencing an issue when attempting to create a Maintenance Plan on a SQL 2008 server. Here is the report:
Maintenance Plan Wizard Progress
- Creating maintenance plan "Daily SQL Maintenance" (Success)
- Adding tasks to the maintenance plan (Success)
- Adding scheduling options (Success)
- Adding reporting options (Success)
- Saving maintenance plan "Daily SQL Maintenance" (Error)
Messages
Saving maintenance plan failed.
-------------------------- ----
ADDITIONAL INFORMATION:
Invalid class string
-------------------------- ----
Invalid class string
Any clues?
Thanks
I'm experiencing an issue when attempting to create a Maintenance Plan on a SQL 2008 server. Here is the report:
Maintenance Plan Wizard Progress
- Creating maintenance plan "Daily SQL Maintenance" (Success)
- Adding tasks to the maintenance plan (Success)
- Adding scheduling options (Success)
- Adding reporting options (Success)
- Saving maintenance plan "Daily SQL Maintenance" (Error)
Messages
Saving maintenance plan failed.
--------------------------
ADDITIONAL INFORMATION:
Invalid class string
--------------------------
Invalid class string
Any clues?
Thanks
Did u install Service Pack Sp1 on SQL 2008. Also Do the login you use has SA privileges?
ASKER
Yes, SP1 is applied. And I've tried performing the maintenance tasks as the actual SA user
ASKER
Just some additional information... if I click the wizard, I get the error described above. If I click straight into "right click maintenance plans and click new maintenance plan", I get the error straight away:
"exception has been thrown by the target of an invocation. (mscorlib)
Additional Information:
Invalid class string
Invalid class string"
"exception has been thrown by the target of an invocation. (mscorlib)
Additional Information:
Invalid class string
Invalid class string"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You are right wolfman007, silly me, I did not install the SQL Integration Services packages. After installing that I could create the maintenance plans no worries.
Thanks for the help
Thanks for the help
ASKER
You are right wolfman007, silly me, I did not install the SQL Integration Services packages. After installing that I could create the maintenance plans no worries.
Thanks for the help, it was great
Thanks for the help, it was great