Unable to create a Maintenance Plan in SQL Server 2008 R2

  • I am unable to create a Maintenance plan. The following error is showing:

    " Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2}

    from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS) "

    How to solve it ?

    Thanks

    Tapas

  • You need to install a cumulative update from Microsoft:

    http://support.microsoft.com/kb/2315727

    Also have a look at this:

    http://support.microsoft.com/kb/981356


    Franco

  • Latest APR 29,2011 Cummulative Update 7 for SQL Server 2008 R2 is available now

    http://support.microsoft.com/kb/2507770

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • Hi,

    Try disabling UAC (User Account Control) and check. This worked for me.

    Thanks,

    Nishad

  • Turn of UAC also worked for me. I think safer than hotfix installs on live servers. You can turn it back on later

    cheers

  • Dear Jahanzaib,

    i created log shipping on sql server 2008 r2

    log created successfully.

    when i run copy job from secondary server job fails. error Access denied login fail for user

    both folders are shared and accessed from both sides.

    the folders have every one read write access

    both users are administrator.

    i have search a lot but no solution

    please help me

    Regards Awais Noman

    ADBA

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply