Re: Setup of 2005 Dev edition Client Components fails

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.


--
Ekrem Önsoy



"Scott M" <ScottM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:B6E39BE1-832B-486A-A677-5C40C03BF514@xxxxxxxxxxxxxxxx
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 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.

--
Ekrem Önsoy



"Scott M" <ScottM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1EE5D9D6-2C8F-4A7B-AEAE-2CB916308BDF@xxxxxxxxxxxxxxxx
> 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
> -----------------------------------------------------------------------------------------------
> "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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:B88CDBC4-1051-4C35-AE9A-B2A9832E64B8@xxxxxxxxxxxxxxxx
>> >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:
>> >
>> >> 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:664D1D07-D2BA-49B0-B14A-C7F452E4D35F@xxxxxxxxxxxxxxxx
>> >> >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
>> >>
>> >>
>>
>>


.

Relevant Pages

  • Re: Installing SQL reporting service with sql 2000 server professional
    ... Report Server is not support on the personal edition of SQL server. ...
    (microsoft.public.sqlserver.server)
  • Re: Insert Speed
    ... I would suggest moving the SQL comment into a stored procedure? ... For each row that you want to insert, not only does it send the entire SQL ... commend to the server, but the server also has to parse and compile the ...
    (microsoft.public.dotnet.general)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)