Post reply

Exception has been thrown by the target of an invocation error while trying to set up a maintenance plan

  • July 25, 2005 at 9:37 am

    #165025

    Hi folks,

    Please help!  I really want to get some screen shots of setting up Maintenance Plans in SQL Server 2005 (I'm using the June CTP).  However, I get this error on two different computers every time I try to create a new plan:

    "Exception has been thrown by the target of an invocation. (mscorlib)"

    "An OLE DB error 0x80004005 ([DBNETLIB][ConnectionOpen] (SECDoClientHandshake()).]SSL Security error.) occurred while enumerating packages. A SQL statement was issues and failed."

    Any ideas?  I found this information but it lead to nowhere:

    http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=56845

    http://sqljunkies.com/Forums/ShowPost.aspx?PostID=7167

    Any help would be greatly appreciated.


    All the best,

    Dale

    Author: An Introduction to SQL Server 2005 Management Studio

  • July 28, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • July 12, 2006 at 1:34 pm

    #648806

    Hi Everyone,

         Did any one find any solution for this. I'm having the same issue on SQL 2005 SP1.

    Dev

     

  • August 5, 2007 at 3:24 am

    #724724

    Does anyone know if there is a solution for this problem?

    I get this error when i try to view or create new database maintenance plans.

    My domain account has enough rights (it used to work).

    I also get this error when i use SQL authentication and use the sa account (when launch SSMS).

    My server is Windows Server 2003 (integrated with SP2) running SQL Server 2005 Standard Edition with SP2

  • August 13, 2007 at 11:08 am

    #726545

    I did 2 things to fix this, first I installed the latest SQL Server SP2 Hotfix (you must be on SP2 prior to installing hotfix).  Then I restarted and my error msg changed a little.  Below is the new error msg and fix:

    Background. When trying to create new or modify existing maintenance plans in Microsoft SQL 2005 SQL Server Management Studio you may get the error “Unable to cast COM object of type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass’ to interface type Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}’ failed due to the following error: Library not registered. (Exception from HRESULT: 0×8002801D (TYPE_E_LIBNOTREGISTERED)). (Microsoft.SqlServer.ManagedDTS)”

    Cause: This error may indicate that you have serious problems with your Microsoft SQL Server 2005 installation, but as the error message says this error often is caused by a type library not is installed. (Not registered.) (dts.dll)

    Solution: Re-register the dts.dll file. On the server, open a command prompt and type: regsvr32 dts.dll

    This worked for me!!

  • October 25, 2007 at 1:08 am

    #745245

    Thanks, it resolved my problem

  • November 27, 2007 at 2:36 am

    #754432

    thanks its solve my Dts problem

    regards

    amlan mohanty

  • January 28, 2008 at 7:38 am

    #772415

    thanks it worked for me 🙂

  • February 26, 2008 at 4:38 am

    #781915

    Excellent! Worked for me too!

  • February 17, 2009 at 7:41 am

    #945197

    Great work finding that problem.. Good dig! This fix worked for me also. Windows 2003 server, SQL 2005 SP2. Same problem as listed above, unable to create maintenance plans. This problem was originally found after applying SQL SP2.

    Thank you!

Viewing 10 posts - 1 through 9 (of 9 total)

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