Link to home
Start Free TrialLog in
Avatar of Craig Rutherford
Craig RutherfordFlag for Vanuatu

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
Avatar of dba2dba
dba2dba

Did u install Service Pack Sp1 on SQL 2008. Also Do the login you use has SA privileges?
Avatar of Craig Rutherford

ASKER

Yes, SP1 is applied. And I've tried performing the maintenance tasks as the actual SA user
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"
ASKER CERTIFIED SOLUTION
Avatar of wolfman007
wolfman007
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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