Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Other SQL Server Topics / August 2007

Tip: Looking for answers? Try searching our database.

Setup of 2005 Dev edition Client Components fails

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scott M - 28 Aug 2007 12:02 GMT
I installed SQL Server Experess edition initially. After I uninstalled
Express I tried to install the Developer edition. The install is failing for
Notification Services, Integration Services and Client Components (or
Workstation Components). Each fails with the message:

"A component that you have specified in the ADD_LOCAL property is already
installed. To upgrade the exisiting component, refer to the template.ini and
set the UPGRADE property to the name of the component."

Does anyone have an idea how to fix this?

Thanks,
Scott
Ekrem Önsoy - 29 Aug 2007 22:48 GMT
Hi Scott,

Some say that you need to uninstall Express Edition completely first and
then try installing Developer Edition and then reinstall Express Edition.

I have not faced any problem like this yet so I didn't have a chance to try
it out. I saw this problem and suggested solution on a forum once.

Let us know the result please?

Signature

Ekrem Önsoy

>I installed SQL Server Experess edition initially. After I uninstalled
> Express I tried to install the Developer edition. The install is failing
[quoted text clipped - 11 lines]
> Thanks,
> Scott
Scott M - 30 Aug 2007 19:44 GMT
I did uninstall the Exress ed. The question is did it uninstall completely.
Then I installed the developer edition 10 different times. All of those
failed. I would be happy to re-install Express, then remove, then re-install
the developer edition if I thought it would fix the problem. But I hate to do
that if it just fails all over again.

> Hi Scott,
>
[quoted text clipped - 21 lines]
> > Thanks,
> > Scott
Ekrem Önsoy - 30 Aug 2007 20:05 GMT
Ok then. Have you checked Event Viewer after you get such errors about
setting up Dev. Ed.?

If you see something in the Event Viewer, please share it with us.
I need the exact message or at least Event ID of it.

Signature

Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT

>I did uninstall the Exress ed. The question is did it uninstall completely.
> Then I installed the developer edition 10 different times. All of those
[quoted text clipped - 33 lines]
>> > Thanks,
>> > Scott
Scott M - 31 Aug 2007 01:10 GMT
Here are the Errors from the Application Event Log.

All of them were Event ID: 1101

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\MSSQL.2\MSSQL\Binn\sqltoolsmailutilities.dll . Error code = 0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\MSSQL.2\MSSQL\Binn\performancecounter.dll . Error code = 0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\SDK\Assemblies\Microsoft.SqlServer.TxScript.dll . Error code =
0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\SDK\Assemblies\Microsoft.SqlServer.ScriptTask.dll . Error code =
0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.XmlTask.dll . Error code = 0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.WMIEWTask.dll . Error code =
0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.WMIDRTask.dll . Error code =
0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.WebServiceTask.dll . Error code =
0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.TransferStoredProceduresTask.dll .
Error code = 0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.TransferSqlServerObjectsTask.dll .
Error code = 0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.TransferObjectsTask.dll . Error code
= 0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.TransferLoginsTask.dll . Error code =
0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.TransferJobsTask.dll . Error code =
0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.TransferErrorMessagesTask.dll . Error
code = 0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.TransferDatabasesTask.dll . Error
code = 0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.TableTransferGeneratorTask.dll .
Error code = 0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.SQLTask.dll . Error code = 0x80131047

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: C:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.SendMailTask.dll . Error code =
0x80131047

There are others but I think you are beginning to see a pattern here...

Also got the following:

Event ID: 1013
Product: Microsoft SQL Server 2005 Tools -- 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.

Event ID: 11724
Product: Microsoft SQL Server 2005 Tools -- Install started.

Event ID: 11708
Product: Microsoft SQL Server 2005 Notification Services -- Installation
failed.

Hopefully this helps...
Thanks,
Scott
-----------------------------------------------------------------------------------------------

> Ok then. Have you checked Event Viewer after you get such errors about
> setting up Dev. Ed.?
[quoted text clipped - 39 lines]
> >> > Thanks,
> >> > Scott
Ekrem Önsoy - 30 Aug 2007 21:47 GMT
I can suggest you to download .Net 2.0 and install it seperately (just give
it a try and see if it installs it correctly.)

You can download it from the following address:
http://www.microsoft.com/downloads/details.aspx?FamilyID=0856EACB-4362-4B0D-8EDD
-AAB15C5E04F5&displaylang=en


Also, please be sure your Windows is up to date. And try SQL Server setup
again.

Signature

Ekrem Önsoy

> Here are the Errors from the Application Event Log.
>
[quoted text clipped - 184 lines]
>> >> > Thanks,
>> >> > Scott
Scott M - 31 Aug 2007 19:20 GMT
I re-installed .Net 2.0 and it still fails. Then I uninstalled ALL of the
.Net versions (1.1, 2.0 & 3.0) then re-installed .Net versions 1.1 and 2.0.
The install of SQL Server Developer Edition still fails. I am now getting the
following message from the System Configuration Check:

EDITION CHANGE CHECK
- Edition Change Check (Warning)
Messages
Edition Change Check

To change an existing instance of Microsoft SQL Server 2005 to a different
edition of SQL Server 2005, you must run SQL Server 2005 Setup from the
command prompt and include the SKUUPGRADE=1 parameter.

The install still fails with the same error messgage. But checking the
Application Event Log the large number of error messages that I listed below
are gone. The only error messsage that I got is:

Event ID: 107
Report Server Windows Service (MSSQLSERVER) cannot connect to the report
server database.

I am going to try and install once again.

Scott

> I can suggest you to download .Net 2.0 and install it seperately (just give
> it a try and see if it installs it correctly.)
[quoted text clipped - 193 lines]
> >> >> > Thanks,
> >> >> > Scott
Ekrem Önsoy - 31 Aug 2007 19:40 GMT
Hello Scott!

Report Server fails if Report Server service attempts to connect to the
database that is not yet online. To fix it, you can try set a dependency to
Report Service.

Go to Regedit
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ReportServer]

Modify or create the DependOnService multi-word value to include
MSSQLSERVER.

Signature

Ekrem Önsoy

>I re-installed .Net 2.0 and it still fails. Then I uninstalled ALL of the
> .Net versions (1.1, 2.0 & 3.0) then re-installed .Net versions 1.1 and
[quoted text clipped - 239 lines]
>> >> >> > Thanks,
>> >> >> > Scott
Scott M - 31 Aug 2007 19:36 GMT
I will email you a screen shot of the error message that I am getting.
Notification Services, Intergration Services and  Workstation Components,
Books Online and Development Tools are failing with the message:

"A component that you have specified in the ADD_LOCAL property is already
installed. To upgrade the exisiting component, refer to the template.ini and
set the UPGRADE property to the name of the component."

Scott

> I can suggest you to download .Net 2.0 and install it seperately (just give
> it a try and see if it installs it correctly.)
[quoted text clipped - 193 lines]
> >> >> > Thanks,
> >> >> > Scott
Scott M - 31 Aug 2007 22:24 GMT
This is really frustrating. I am jumping through hoops just to get the
product installed. Here is a copy of the Summary Log:

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build
2600)
Time            : Fri Aug 31 16:56:10 2007

SCOTTLAPTOP : To change an existing instance of Microsoft SQL Server 2005 to
a different edition of SQL Server 2005, you must run SQL Server 2005 Setup
from the command prompt and include the SKUUPGRADE=1 parameter.
Machine         : SCOTTLAPTOP
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
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\SQLSetup0015_SCOTTLAPTOP_OWC11_1.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.2004
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_BackwardsCompat_1.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_MSXML6_1.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
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\SQLSetup0015_SCOTTLAPTOP_OWC11_2.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.2004
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_BackwardsCompat_2.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_MSXML6_2.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_SQLSupport_3.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_SQLNCLI_3.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
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\SQLSetup0015_SCOTTLAPTOP_OWC11_3.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
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\SQLSetup0015_SCOTTLAPTOP_BOL_1.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.2004
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_BackwardsCompat_3.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_MSXML6_3.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
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         : SCOTTLAPTOP
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\SQLSetup0015_SCOTTLAPTOP_DTS.log
Error Number    : 1603
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : SQLXML4
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_SQLXML4_1.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
Product         : SQLXML4
Product Version : 9.00.3042.00
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0015_SCOTTLAPTOP_SQLXML4_2.log
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
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         : SCOTTLAPTOP
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\SQLSetup0015_SCOTTLAPTOP_NS.log
Error Number    : 1603
--------------------------------------------------------------------------------
Machine         : SCOTTLAPTOP
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         : SCOTTLAPTOP
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\SQLSetup0015_SCOTTLAPTOP_Tools.log
Error Number    : 1603
--------------------------------------------------------------------------------
Ekrem Önsoy - 31 Aug 2007 21:04 GMT
Hello Scott!

Go to the following address:
http://support.microsoft.com/kb/909967

Uninstall SQL Server from your computer manually by help of the mentioned
address.

And then install SQL Server again. This should work this time.

Signature

Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT

> This is really frustrating. I am jumping through hoops just to get the
> product installed. Here is a copy of the Summary Log:
[quoted text clipped - 181 lines]
> Error Number    : 1603
> --------------------------------------------------------------------------------
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.