Wednesday, March 21, 2012

Installing SQL Server 2005 Integration Services

I tried removing and reinstalling SQL Server 2005 Developer Edition for three times, including "all-at-once" component installation and "component-by-component" and I just can't get Integration Services to install.

Here is the setting:
- I have WinXPPro SP2
- I had SQL2K and removed it
- I installed SQL2k5 (as described above)

I am getting the following error:

Microsoft SQL Server 2005 Integration Services -- A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component.

This component of course is not installed. I believe it has to do something with the registry - when SQL2K was removed it didn't clean the registry. I tried with

setup /qb addlocal=SQL_DTS

and later with

setup /qb upgrade=SQL_DTS

w/o success.

Anyone any ideas?
Thanks,

AlesIf this helps, here is some additional info: I ran the Report and got the following list of components I have installed:

ALBATROS

The following components are installed on this server

MSSQLSERVER

Analysis Services

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: English (United States)]

Database Engine

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: English (United States)]

Reporting Services

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: English (United States)]

Common components

Workstation Components

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: English (United States)]

Since Integration Services is not on the list I am really lost.

Thanks again for your help,

Ales

|||I haven't seen this problem before - isn't it fun being the first one to hit something. Big Smile

Try uninstalling SSIS from the command line: setup.exe /qb remove=SQL_DTS and let's see what happens.|||I got the same problem. I tried your way. No luck. I also have SQL server 2000 installed. I thought its management tools and online help might have some registry conflict with SQL server 2005.|||I also got the same problem! and I also got MS SQL 2000 installed. I uninstalled this SQL2000 instance already, but no luck. Has anyone been able to find a solution for this issue cause it really is driving me nuts.
|||Have you tried running the MSI Cleanup utility? It could be that even though the components are no longer installed, MSI thinks they are, and therefore will not let you re-install them. You can get the MSICUU here > http://support.microsoft.com/default.aspx/kb/290301
sql

No comments:

Post a Comment