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

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?


--
Ekrem Önsoy


"Scott M" <ScottM (AT) discussions (DOT) microsoft.com> wrote

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.

"Ekrem Önsoy" wrote:

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.

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



"Scott M" <ScottM (AT) discussions (DOT) microsoft.com> wrote

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/d...displaylang=en

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

--
Ekrem Önsoy



"Scott M" <ScottM (AT) discussions (DOT) microsoft.com> wrote

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.dl l . 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.TxScr ipt.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.Scrip tTask.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.dl l . 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.WebService Task.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.TransferSt oredProceduresTask.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.TransferSq lServerObjectsTask.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.TransferOb jectsTask.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.TransferLo ginsTask.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.TransferJo bsTask.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.TransferEr rorMessagesTask.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.TransferDa tabasesTask.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.TableTrans ferGeneratorTask.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.dl l . 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.SendMailTa sk.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
-----------------------------------------------------------------------------------------------
"Ekrem Önsoy" wrote:

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

"Ekrem Önsoy" wrote:

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

"Ekrem Önsoy" wrote:

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\Servic es\ReportServer]

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


--
Ekrem Önsoy



"Scott M" <ScottM (AT) discussions (DOT) microsoft.com> wrote

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.


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



"Scott M" <ScottM (AT) discussions (DOT) microsoft.com> wrote