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.
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