Unable to create Maintenance Plans in SQL Server 2005 SP3 RRS feed

  • Question

  • Hi All

    I recently updated my installation of SQL Server 2K5 to SP3 and now am at version 9.0.4035

    (1) I am unable to open any maintenance plan getting the following error :-
             Value cannot be Null
             Parameter name: component (System.design)

    (2) Similarly when I try to create a new maintenance plan I get the following error:-
             Exception has been thrown by the Target of an invocation. (mscorlib)
             Additional Information:
                 An OLE DB error 0x80004005 (Unspecified error) occured while enumerating packages. A SQL statement was 
                 issued and failed.

    (3) Finally when I try to use the Maintenance Plan wizard to create a new maintenance plan, after select all the options, the wizard runs but fails at the last step ('Saving Maintenance Plan "XXYYYZZZ") with the same error as in (2) above

    Has anyone got any suggestions as to what I can do to sort this problem out?

    • Moved by liurong luo Friday, August 21, 2009 1:32 AM not a Profiler issue. (From:Visual Studio Performance Tools (Profiler))
    Thursday, August 20, 2009 2:55 PM