Thursday, February 28, 2013

SQL 2005 Integration Service Installation Error

Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -xxxxx
Error message: Unspecified error
Error HRESULT E_FAIL has been returned from a call to a COM component
If you  getting this error in between installing a cluster, you can skip it and install SSIS on the node where you are getting
On the node where you have issue -
1) Deleting MSMQTask COM+ Components from Component Services:
- Open: Start\Programs\Administrative Tools\Components Services,
- Expand "Component Services" -> "My Computer" -> "COM+ Applications",
- You'll see "Microsoft.SqlServer.MSMQTask" component. Right click on it and Delete it.
- If that dialog box is open which poped up during SQL Server Setup then click Retry, otherwise start over and this problem will be gone.
Try to restart the installation
2) If that dosent work - ignore the error and install SSIS
3) Reboot Server
4) Once it comes back, un-install SSIS
5) Reboot the Server
6) Install SSIS again this time it shoud get installed with out issues!

No comments: