Hi, All:

when I do a SQL server upgrade on a server with sql 2000, I kept getting
"upgradeAdvisor returned -1" error

Does anybody know what caused? If I click ? and bring me to MS web site
EvtType 29552 and LinkID 20476........

Thank you in advance.

I am getting the same error as well while trying to upgrade an existing
database. The error suggests this link:
http://go.microsoft.com/fwlink?LinkI...&EvtType=29552

I gave the above suggestion a shot with no luck....

Has anyone encountered this?

Thanks,
Prince

"ginger8990" wrote:

Guess nobody expereience this problem. I re-produce the error again on
another machine so I uninstall all the .net frame works then login locally,
it seems working. I had patched .NET 3.5 recently

"Prince" wrote:

I got this problem as well.

and when I look at the event log of application, here are the message:
*****************************
Event Type: Error
Event Source: .NET Runtime Optimization Service
Event Category: None
Event ID: 1101
Date: 07/05/2009
Time: 17:32:53
User: N/A
Computer:
Description:
..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002


For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

*********************
our server already had Microsoft updates installed: .NET 2.0 with SP2 and
..NET 3.0 with SP1 also .NET3.5 SP1
by looking above log, it looks like the .NET framework comes with SQL2005
installation CD is NOT compatible with up to date .NET firmware that
Microsoft released.

What a great job!!.

has to uninstall from the highest .NET framework to the lowest and run the
sql 2005 installation program again. works.

Cheers,
Marvel




"ginger8990" wrote:

I found the error, courtesy of Ed Freels on the Expertsexchange website.


And I quote:
__________________
I went through each of the log files and apparently the upgrade advisor
does not log in it's process. The first link that you posted to a
search for this error shows "no results found". The second link did not
supply any resolution as well.

I ended up having to contact Microsoft support to get the problem
resolved. Apparently the upgrade placed a dll in the wrong folder that
applies to the upgrade advisor thus the upgradeadvisor error. They had
no explanation other than sometimes this happens.

Here is the resolution:

Copy C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\BPA\bin\BPAClient.dll to C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\BPA.

That's it. Once the dll is in the bpa folder, upgrade advisor works
successfully and the upgrade runs through successfully.
__________________


Thats it. One file installed incorrectly. Thanks Microsoft!




I am posting this here because it took me about an hour of googling to
find the correct answer. The more places it is, the better!

*** Sent via Developersdex http://www.developersdex.com ***

Thank you for this solution!!



"mmgm" wrote:

Hello,

Just uninstall all existing .NET frameworks and then install .NET 2.0.


"ScottT" wrote: