Error messages when upgrading from SQL 2008 RC0 to RTM

Error messages when upgrading from SQL 2008 RC0 to RTM by Javier Villegas

Closed

as Fixed

Type:	Bug
ID:	363653
Opened:	8/26/2008 12:29:16 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

We got different error messages when upgrading from SQL 2008 RC0 to RTM. The first one is “The following error has occurred: Not Found. Click Retry ….” While installing SqlRSConfigAction_upgrade_shutdowninstance_cpu64 (See attached screenshots). Nothing happened when clicked on retry so I had to did click on Cancel. The installation moved forward but then it returned another message “The process cannot access the file C:\Windows\system32\perf-ReportServer-rsctr.dll because it is being used by another process”
Same behavior upgrading a x64 cluster sql2008 Ent Ed on Windows 2008, x64 standalone Ent Ed on Windows 2008, x86 sql 2008 Dev Ed.

Details (expand)

English

SQL Server 2008 - Enterprise Edition

Setup

Windows Server 2008

US English

Upgrade from SQL 2008 RC0 to RTM

“The following error has occurred: Not Found. Click Retry ….” While installing SqlRSConfigAction_upgrade_shutdowninstance_cpu64

The process cannot access the file C:\Windows\system32\perf-ReportServer-rsctr.dll because it is being used by another process”

Clean upgrade process

X64

File Name	Submitted By	Submitted On	File Size
Upgrade to SQL 2008 RTM Errors.doc (restricted)	Javier Villegas	8/26/2008	-

Posted by Mike Honey - Manga Solutions on 9/23/2011 at 6:34 PM

I just struck this issue upgrading from SQL 2008 SP1 to 2008 R2 on an x64 server running Windows Server 2008 R2 Standard. Ref link I've posted in Workarounds for a workaround I found that seems to work.

Posted by DJ Spy on 1/6/2011 at 9:16 AM

kill "WmiPrvSE.exe"

Posted by gnease on 6/29/2010 at 10:26 AM

I am getting this exact symptom in an upgrade from SQL 2008 Standard RTM to R2 on both of our x64 machines.

Posted by Microsoft on 12/31/2008 at 9:21 PM

Thank you for filing this bug.

After further investigation, we have determined this can happen when an app (such as perfmon) has locked this dll down. If should be able to workaround / avoid this error by closing the application locking down this dll and then re-run uninstall. In any case, we have decided to fix this in the Killimanjaro release of SSRS.

HTH
Prash

Posted by Mike Honey - Manga Solutions on 9/23/2011 at 6:35 PM

Temporarily stop the service: Windows Management Instrumentation

Thanks to : http://sql-kevin.blogspot.com/2011/04/sql-server-2008-r2-upgrade-perf.html

Posted by Uwe Keim on 7/4/2010 at 11:21 AM

It happened on my server, too. Solution was to complete close and exit SysInternal's Process Explorer.