Saturday, February 25, 2012

Problem installing some components SQL 2005

Hi,

I'm having trouble installing SQL2005 completely. I get a message:
"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."

It concerns "Integration services", "Notification services" and "Workstation Components, Books Online and Development Tools"

What should I do?

Regards,
Ronald

Here is the complete listing of summary.txt:

Microsoft SQL Server 2005 9.00.1399.06

==============================

OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)

Time : Sat Nov 12 21:29:32 2005

Machine : VL023188

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLSupport_1.log

--

Machine : VL023188

Product : Microsoft SQL Server Native Client

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLNCLI_1.log

--

Machine : VL023188

Product : Microsoft Office 2003 Web Components

Product Version : 11.0.6558.0

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_OWC11_1.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Backward compatibility

Product Version : 8.05.1054

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BackwardsCompat_1.log

--

Machine : VL023188

Product : MSXML 6.0 Parser

Product Version : 6.00.3883.8

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_MSXML6_1.log

--

Machine : VL023188

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLSupport_2.log

--

Machine : VL023188

Product : Microsoft SQL Server Native Client

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLNCLI_2.log

--

Machine : VL023188

Product : Microsoft Office 2003 Web Components

Product Version : 11.0.6558.0

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_OWC11_2.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Backward compatibility

Product Version : 8.05.1054

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BackwardsCompat_2.log

--

Machine : VL023188

Product : MSXML 6.0 Parser

Product Version : 6.00.3883.8

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_MSXML6_2.log

--

Machine : VL023188

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLSupport_3.log

--

Machine : VL023188

Product : Microsoft Office 2003 Web Components

Product Version : 11.0.6558.0

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_OWC11_3.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Backward compatibility

Product Version : 8.05.1054

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BackwardsCompat_3.log

--

Machine : VL023188

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLSupport_4.log

--

Machine : VL023188

Product : Microsoft SQL Server Native Client

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLNCLI_3.log

--

Machine : VL023188

Product : Microsoft Office 2003 Web Components

Product Version : 11.0.6558.0

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_OWC11_4.log

--

Machine : VL023188

Product : Microsoft SQL Server VSS Writer

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SqlWriter_1.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Backward compatibility

Product Version : 8.05.1054

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BackwardsCompat_4.log

--

Machine : VL023188

Product : MSXML 6.0 Parser

Product Version : 6.00.3883.8

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_MSXML6_3.log

--

Machine : VL023188

Product : Microsoft SQL Server Setup Support Files (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLSupport_5.log

--

Machine : VL023188

Product : Microsoft SQL Server Native Client

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLNCLI_4.log

--

Machine : VL023188

Product : Microsoft Office 2003 Web Components

Product Version : 11.0.6558.0

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_OWC11_5.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Books Online (English)

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BOL_1.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Backward compatibility

Product Version : 8.05.1054

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_BackwardsCompat_5.log

--

Machine : VL023188

Product : MSXML 6.0 Parser

Product Version : 6.00.3883.8

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_MSXML6_4.log

--

Machine : VL023188

Product : Integration Services

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

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Integration Services

Product Version : 9.00.1399.06

Install : Failed

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_DTS.log

Error Number : 1603

--

Machine : VL023188

Product : SQLXML4

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLXML4_1.log

--

Machine : VL023188

Product : Microsoft SQL Server 2005

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQL.log

--

Machine : VL023188

Product : SQLXML4

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_SQLXML4_2.log

--

Machine : VL023188

Product : Notification Services

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

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Notification Services

Product Version : 9.00.1399.06

Install : Failed

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_NS.log

Error Number : 1603

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Reporting Services

Product Version : 9.00.1399.06

Install : Successful

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_RS.log

--

Machine : VL023188

Product : Workstation Components, Books Online and Development Tools

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

--

Machine : VL023188

Product : Microsoft SQL Server 2005 Tools

Product Version : 9.00.1399.06

Install : Failed

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_VL023188_Tools.log

Error Number : 1603

--

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Let's start by looking at what's already installed on your machine. The error you're getting usually means the component is already installed. To figure out what's installed, go to Add/Remove Programs and find the entry for "SQL Server 2005". Select that entry and click Change. Once the dialog appears you should see a button named "Report". Click that button and you'll get a report detailing your installation. Select the contents of that report and copy/paste them into a reply here. Once we determine what you have installed we can figure out what you need to do.

Dan|||

Below the output of "Report". I also found out that there are a number of CTP rows in the add/remove software list. I thought I removed all SQL components but this morning after rebooting I discovered these components and I don't know where they come from. I have installed VS2005 also after installing SQL2005. Should I remove those CTP components? And in what order?
Perhaps you should also know that I removed all SQL branches in the registry (9.00....) because the installation of SQL2005 wouldn't start.
VL023188

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: Engels (Verenigde Staten)]

Database Engine

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: Engels (Verenigde Staten)]

Reporting Services

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: Engels (Verenigde Staten)]

SQLEXPRESS

Database Engine

[Version: 9.00.1399.06 Edition: Express Edition Patch level: 9.00.1399.06 Language: Engels (Verenigde Staten)]

|||

Well, I managed to uninstall most of the CTP components. Just one is left that I cannot uninstall: Microsoft SQL Server Tools CTP. This one is looking into a directory that doesn't exist anymore. I can see that it was the SQL 2005 September CTP enterprise edition but I don't have that one anymore (also not available for subscribers?). How can I uninstall this one?

|||I found out that the report services weren't functioning very well (I was not able to open an existing report project). So I uninstalled the component reporting services (in add/remove, change on SQL2005). But after that I am not able to reinstall reporting services because:

Machine : VL023188
Product : Reporting Services

Error : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
-
Machine : VL023188
Product : Microsoft SQL Server 2005 Reporting Services
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0023_VL023188_RS.log
Last Action : DetectInstanceClash
Error String : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Error Number : 28086
-

What to do?

|||

Plenty wrote:

Well, I managed to uninstall most of the CTP components. Just one is left that I cannot uninstall: Microsoft SQL Server Tools CTP. This one is looking into a directory that doesn't exist anymore. I can see that it was the SQL 2005 September CTP enterprise edition but I don't have that one anymore (also not available for subscribers?). How can I uninstall this one?

I got a solution for this problem:
http://blogs.msdn.com/brada/archive/2005/06/24/432209.aspx

This helped me, now I could install the tools

But the one above still isn't solved (reporting services, existing instance). How can I remove that exsiting instance?|||

Try the following:

1. Kill the service with command sc if it still exists.

2. Go to Registry editor, remove those registy keys related to the service. You need to search the whole regisgtry tree.

3. Reboot the machine.

No comments:

Post a Comment