Cannot install error code is :-2147467259. Workstation Components ...

I cannot get the the workstation components to install. Below is the error.

SI (s) (C0:58) [13:25:36:394]: Note: 1: 1708
MSI (s) (C0:58) [13:25:36:394]: Product: Microsoft SQL Server "Katmai" Tools -- Installation failed.

MSI (s) (C0:58) [13:25:44:996]: Cleaning up uninstalled install packages, if any exist
MSI (s) (C0:58) [13:25:45:056]: MainEngineThread is returning 1603
MSI (s) (C00) [13:25:45:387]: Destroying RemoteAPI object.
MSI (s) (C0:00) [13:25:45:727]: Custom Action Manager thread ending.
=== Logging stopped: 6/4/2007 13:25:35 ===
MSI (c) (98:94) [13:25:46:047]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (98:94) [13:25:46:298]: MainEngineThread is returning 1603
=== Verbose logging stopped: 6/4/2007 13:25:46 ===

Can you log a bug on Connect and attached the error logs please. We'll take a look.

Dan Bien

SQL Setup

|||

In the machine that you installed Katmai,do you have another version of SQL Server?Because in the katmai site has a document speaking that before you install katmai,remove the workstation components of Sql Server 2005...

4.3.3 Installing SQL Server "Katmai" Removes Support for DTS in SQL Server 2005 Integration Services Packages

For this CTP release, you must uninstall SQL Server 2005 Workstation Components before installing the SQL Server "Katmai" Workstation Components. Uninstalling the SQL Server 2005 Workstation Components removes three Integration Services components: the SQL Server 2005 version of the Execute DTS 2000 Package task and two supporting assemblies. These three Integration Services components support backward compatibility between SQL Server 2005 and SQL Server 2000 Data Transformation Services (DTS). Without these three components, SQL Server 2005 packages and tools that require DTS support will not run.

However, SQL Server "Katmai" Integration Services includes a version of the Execute DTS 2000 task and the two supporting assemblies. Therefore, you can upgrade SQL Server 2005 packages that require DTS support to the SQL Server "Katmai" format by opening them in the SQL Server "Katmai" version of Business Intelligence Development Studio, and then running those packages as SQL Server "Katmai" packages.

|||

If you have not uploaded the log files yet, please see the other post on this subject:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1693821&SiteID=1

This error occurs usually due to the fact that VS is installed in a non-default location.

Max Verun

SQL Server