[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 606
  • Last Modified:

Error in MS-SQL 2005

I notice that my daily DB backup job in SQL is not working anymore.  So I went and edit the job to see what is going on.  Here is the error I am getting:

===================================

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: Interface not registered (Exception from HRESULT: 0x80040155). (Microsoft.SqlServer.ManagedDTS)

------------------------------
Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Package..ctor()
   at Microsoft.DataTransformationServices.DTSExecUI.Controls.LoggingCtrl..ctor(IDTSExecViewManager treePanel)
   at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition.InitializeControls()
   at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition..ctor(CDataContainer dataContainer, IMessageBoxProvider messageProvider)
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepSubSystems..ctor(CDataContainer dataContainer, JobStepData data, IMessageBoxProvider messageProvider)
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.get_SubSystems()
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.InitializeStepCombo()
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.InitializeData()
   at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.OnInitialization()
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node)
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SelectCurrentNode()
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.InitializeUI(ViewSwitcherTreeView treeView, ISqlControlCollection viewsHolder, Panel rightPane)
   at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
   at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(ISqlControlCollection control, IServiceProvider provider)
   at Microsoft.SqlServer.Management.SqlManagerUI.JobSteps.editJob_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Thank you,
0
pctechaegera
Asked:
pctechaegera
  • 7
  • 2
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Re-register the dts.dll file. On the server, open a command prompt and type:

regsvr32 dts.dll

Ref:
http://www.folin.se/index.php/2007/06/08/unable-to-cast-com-object-of-type-microsoftsqlserverdtsruntimewrapperpackagene-utralclass/michaelfolin

Also Apply SP3 for SQL Server 2005..
0
 
pctechaegeraAuthor Commented:
Ok the regsvr32 dts.dll fix the issue.  As for the service pack 3, I try in the past to install it but it allways fail with an error.  I will try again.  I keep you posted.

Thank you,
0
 
pctechaegeraAuthor Commented:
I try to install the service pack 3 again and it fail like before.  Also, the maintenance plan is failing now.  It says to have a look at the log for more detail.  Where are these log?

Thank you,
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
pctechaegeraAuthor Commented:
Here is the report a got after the SP3 fail installation:

Time: 12/18/2009 10:28:13.954
KB Number: KB955706
Machine: SVR-SQL
OS Version: Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 3
Package Version: 4035
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected                         Language  Level  Patch Level       Platform  Edition
Setup Support Files                       ENU                     9.3.4035  x86      
Database Services (MSSQLSERVER)           ENU       RTM    2005.090.1406.00  x86       STANDARD
Analysis Services (MSSQLSERVER)           ENU       RTM    2005.090.1406.00  x86       STANDARD
Reporting Services (MSSQLSERVER)          ENU       SP3       9.00.4035.00  x86       STANDARD
Notification Services                     ENU       SP3       9.00.4035.00  x86       STANDARD
Integration Services                      ENU       SP3       9.00.4035.00  x86       STANDARD
SQL Server Native Client                  ENU                 9.00.4035.00  x86      
Client Components                         ENU       SP3           9.3.4035  x86       STANDARD
MSXML 6.0 Parser                          ENU                  6.20.1099.0  x86      
SQLXML4                                   ENU                 9.00.4035.00  x86      
Backward Compatibility                    ENU                    8.05.2312  x86      
Microsoft SQL Server VSS Writer           ENU                 9.00.4035.00  x86      

**********************************************************************************
Products Disqualified & Reason
Product                                   Reason

**********************************************************************************
Processes Locking Files
Process Name          Feature               Type          User Name                  PID
msftesql              Database Services     Service       NT AUTHORITY\SYSTEM        2348
MSSQLSERVER           Database Services     Service       NT AUTHORITY\SYSTEM        1772
SQLSERVERAGENT        Database Services     Service       NT AUTHORITY\SYSTEM        2636
SQLBrowser            Database Services     Service       NT AUTHORITY\SYSTEM        2068
MSSQLServerOLAPService  Analysis Services     Service       NT AUTHORITY\SYSTEM        1796

**********************************************************************************
Product Installation Status
Product                   : Setup Support Files
Product Version (Previous): 4035
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
Error Description         :
----------------------------------------------------------------------------------
Product                   : Database Services (MSSQLSERVER)
Product Version (Previous): 1406
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
Error Number              : 29512
Error Description         : MSP Error: 29512  SQL Server Setup was unable add user NT AUTHORITY\SYSTEM to local group AEGERA\SQLServer2005SQLAgentUser$SVR-SQL$MSSQLSERVER.
----------------------------------------------------------------------------------
Product                   : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1406
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB955706_sqlrun_as.msp.log
Error Number              : 29512
Error Description         : MSP Error: 29512  SQL Server Setup was unable add user NT AUTHORITY\SYSTEM to local group AEGERA\SQLServer2005MSOLAPUser$SVR-SQL$MSSQLSERVER.
----------------------------------------------------------------------------------
Product                   : Reporting Services (MSSQLSERVER)
Product Version (Previous): 4035
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
Error Number              : 0
Error Description         :
----------------------------------------------------------------------------------
Product                   : Notification Services
Product Version (Previous): 4035
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
Error Description         :
----------------------------------------------------------------------------------
Product                   : Integration Services
Product Version (Previous): 4035
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
Error Description         :
----------------------------------------------------------------------------------
Product                   : SQL Server Native Client
Product Version (Previous): 4035
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
Error Description         :
----------------------------------------------------------------------------------
Product                   : Client Components
Product Version (Previous): 4035
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
Error Description         :
----------------------------------------------------------------------------------
Product                   : MSXML 6.0 Parser
Product Version (Previous): 1099
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
Error Description         :
----------------------------------------------------------------------------------
Product                   : SQLXML4
Product Version (Previous): 4035
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
Error Description         :
----------------------------------------------------------------------------------
Product                   : Backward Compatibility
Product Version (Previous): 2312
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
Error Description         :
----------------------------------------------------------------------------------
Product                   : Microsoft SQL Server VSS Writer
Product Version (Previous): 4035
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
Error Description         :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
     One or more products failed to install, see above for details
     Exit Code Returned: 29512

0
 
pctechaegeraAuthor Commented:
Ok, the failing installation of SP3 is what causes the initial problem.  After I try installing SP3 the initial problem return.  So I guess the SP3 problem needs to be found in order to fix the other issue for good.
0
 
pctechaegeraAuthor Commented:
I follow the instruction on this web site and it work.
http://groups.google.com/group/microsoft.public.windowsupdate/msg/987cc03d02cf9db4

Thank you for your help.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
If you have resolved the issue, then kindly request you to close out this question accordingly..
0
 
pctechaegeraAuthor Commented:
I did closed it last week, I dont understand.  Anyway, I did closed it again.
0
 
pctechaegeraAuthor Commented:
I cant close it twice.  I did closed it last week.  I try again, but I am being told that it is close???
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 7
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now