Microsoft KB Archive/907888

= Error message when you install the SQL Server 2000 DTS Designer components on a computer that is running Windows 2000: &quot;dtsui.dll failed to register HRESULT -2147024770&quot; =

Article ID: 907888

Article Last Modified on 11/20/2007

-

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 Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft 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://msdn2.microsoft.com/en-us/sql/aa336314.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://msdn2.microsoft.com/en-us/data/aa937729.aspx/



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

Keywords: kbtshoot kbbug kbprb kbexpertiseadvanced kbsql2005setup kbsql2005webdata KB907888

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.