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
Craig RutherfordAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
wolfman007Connect With a Mentor Commented:
When you installed SQL Server 2008 did you install Integration Services?

If you did not install Integration Services then you cannot create Database Maintenance Plans.

Database Maintenance Plans are SQL Server Integration Services packages which require Integration Services to run.

Run the installation program again and add Integration Services to your server and you Database Maintenance Plans should work.
0
 
dba2dbaCommented:
Did u install Service Pack Sp1 on SQL 2008. Also Do the login you use has SA privileges?
0
 
Craig RutherfordAuthor Commented:
Yes, SP1 is applied. And I've tried performing the maintenance tasks as the actual SA user
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Craig RutherfordAuthor Commented:
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"
0
 
Craig RutherfordAuthor Commented:
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
0
 
Craig RutherfordAuthor Commented:
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
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.