ERROR MESAGGE:
“Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2147467259 Error message: Unspecified error Error description: Error HRESULT E_FAIL has been returned from a call to a COM component.”
EXPLANATION:
The problem is because Microsoft.SqlServer.MSMQTask.dll cannot register in the Operating System. In particular, when trying to install 64Bit Integration Services, this error can be encountered if there are 32Bit .Net Framework components on the system.
SOLUTION:
To solve the problem, you can unregister and reregister Microsoft.SqlServer.MSMQTask.dll as follows.
To Unregister:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>regsvcs /u “C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll”
Microsoft (R) .NET Framework Services Installation Utility Version 2.0.50727.42 Copyright (c) Microsoft Corporation. All rights reserved. Uninstallation of assembly ‘C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll’ succeeded.
To Register:
C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727>regsvcs.exe “C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll”
Microsoft (R) .NET Framework Services Installation Utility Version 2.0.50727.42 Copyright (c) Microsoft Corporation. All rights reserved.
