InteropServices.COMException (0x80040154): Retrieving the COM class

Problem

You may get the following error when you are installing stored procedures into your database using Iron Speed Designer, LoadStoredProcedures or when you run the MSI installer.

System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154

The error occurs because SQL Distributed Management Objects (SQL-DMO) is not installed on your system where you are running Iron Speed Designer, LoadStoredProcedures or the MSI installer.

Solution

SQL-DMO is available as part of "Microsoft SQL Server 2005 Backward Compatibility Components" available from Microsoft and is available for download from:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c&displaylang=en

The web page contains a link to download the SQL-DMO component 32-bit or 64-bit systems.

Please note that if you are using LoadStoredProcedures.bat, you can run this from any system as long as a connection to the database is available from that system. It is not necessary to run it from the production server. As long as you can access SQL Server from the system where you are running LoadStoredProcedures.bat, you will be able to load the stored procedures.