SKUUPGRADE of Reporting Services fails with could not write rssrvpolicy.config

Question

Hi,

 

I'm using the System Center Essential 2007 VHD (http://go.microsoft.com/fwlink/?LinkId=91061). It has an SQL Server Express Edition with Advanced Services installed as a named instance, SCEVHD\SCE. I tried to upgrade the SQL Server to Enterprise Edition, because some of the reports are not working in Express. I started the setup with the SKUUPGRADE=1 switch, it found the SQL Engine and Reporting Services components and offered to upgrade them. Upgrading the SQL Engine was successful, however the Reporting Services failed with the following error:

 

SQL Server Setup did not have the administrator permissions required to copy a file: C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\rssrvpolicy.config. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.

 

I checked the file, it exists and the current account (which is a domain administrator) has permissions. I stopped all services which could use the reporting services, rerun the setup now only for reporting services, but the same error occured. For the third try I started Filemon also, and it captured the following trace.

http://mit.bme.hu/~micskeiz/files/sql-rs-install-error.jpg

From this I guess the following: until row 442 it checks the existense of the target folder and creates the folder for the upgraded instance in C:\Program Files\Microsoft SQL Server\MSSQL.4. In step 443 probably it wants to copy the old config, but it searches them in the C:\Program Files\Microsoft SQL Server\MSSQL.2 folder, which should be the location of a default reporting services install. However, the setup of System Center Essentials installs its SQL Server Express Reporting Services in C:\Program Files\System Center Essentials 2007\Microsoft SQL Server\MSSQL.2, thus the setup fails because it is looking for rssrvpolicy.config in the wrong folder.

Do I see the problem correctly?

The setup log can be found here: http://mit.bme.hu/~micskeiz/files/SQLSetup0005_SCEVHD_RS.log

 

I tried to do a command line install, but I did not found a switch to tell the old location of Reporting Services. Neverthless I tried the following command:

D:\>start /wait setup.exe ADDLOCAL=RS_Server INSTANCENAME=SCEVHD\SCE UPGRADE=RS_
Server SKUUPGRADE=1 /qb

But the setup said that the requested component could not be found.

 

Any suggestions?

 

Thanks,

Zoltan

(I will be on vacation from next week, so I could not respond for a week.)

Answer 1

Ok, I found a temporary solution: I simply copied the MSSSQL.2 folder to c:\program file\microsoft sql server, and with this, the upgade was successfull :-). But anyway, it still seems a bug to me, and the nasty part of it is, that it reports a problem with not able to copy to the destination file, while the problem is with the source file.

 

Zoltan

Answer 2

Even after 2 years this is still very helpfull.

Thanks.