Error message when you install the SQL Server 2000 DTS Designer components on a computer that is running Windows 2000: "dtsui.dll failed to register HRESULT -2147024770" (907888)


The information in this article applies to:

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Service Pack 1

Bug #: 406911 (SQLBUDT)

SYMPTOMS

When you install the Microsoft SQL Server 2000 Data Transformation Services (DTS) Designer components on a computer that is running Microsoft Windows 2000, you receive the following error message:

dtsui.dll failed to register. HRESULT -2147024770
For more information about the SQL Server 2000 DTS Designer components, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn.microsoft.com/SQL/bi/integration/downloads/default.aspx

CAUSE

This behavior occurs because the SQL Server 2000 DTS Designer components require that you have Microsoft Data Access Components (MDAC) 2.6 Service Pack 2 (SP2) or a later version of MDAC installed on the computer.

RESOLUTION

To resolve this behavior, upgrade the existing version of MDAC to MDAC 2.6 SP2 or to a later version of MDAC. We recommend that you upgrade the existing version of MDAC to the latest version.

For more information about how to upgrade MDAC, visit the following MSDN Web site:

http://msdn.microsoft.com/data/ref/mdac/

STATUS

This behavior is by design.

MORE INFORMATION

The SQL Server 2000 DTS Designer components let you edit and maintain the existing SQL Server 2000 DTS packages in SQL Server 2005 Integration Services (SSIS). Therefore, you do not have to install the original SQL Server 2000 tools to edit and to maintain the existing SQL Server 2000 DTS packages.

Management tools or database engine components for SQL Server 2000 Service Pack 3a or for a later SQL Server 2000 service pack already contain MDAC 2.6 SP2 or a later version of MDAC. If you already have one of these tools or one of these database engine components installed on the computer, this behavior does not occur when you install the SQL Server 2000 DTS Designer components.

If the computer is running Windows 2000, the version of MDAC that is installed on the computer may be earlier than MDAC 2.6 SP2. Before you start to install the SQL Server 2000 DTS Designer components on a computer that is running Windows 2000, make sure that MDAC 2.6 SP2 is already installed or that a later version of MDAC is already installed.

You can obtain the latest version of MDAC, and then you can manually upgrade the existing version. Additionally, applications such as SQL Server 2005 may include a later version of MDAC than MDAC 2.6 SP2. However, if the computer is running Windows 2000 and if you do not install the MDAC upgrades, MDAC 2.5 remains installed on the computer. Windows 2000 service packs only include service packs for MDAC 2.5. These Windows 2000 service packs do not upgrade the existing version of MDAC to MDAC 2.6 SP2 or to a later version of MDAC.

Microsoft Windows XP and Microsoft Windows Server 2003 include MDAC 2.6 SP2 or a later version of MDAC. This behavior does not occur if you install the SQL Server 2000 DTS Designer components on a computer that is running Windows XP or Windows Server 2003.

You can use the MDAC Component Checker tool to determine the version of MDAC that is installed on the computer. To download the MDAC Component Checker tool, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en

Modification Type:MajorLast Reviewed:7/19/2006
Keywords:kbExpertiseAdvanced kbprb kbsql2005webdata kbsql2005setup kbtshoot kbbug KB907888 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.