DavidJW


We have SQL 2005 standard edition and Reporting Services installed on the same server. We are now upgrading from standard to enterprise edition, so we ran setup and let it do its thing. This upgraded SQL Server without any problems but it failed to upgrade Reporting Services. We got a message saying "...set up did not have the administrator permissions required to copy a file: C:\Program Files\Microsoft SQL Server\MSSQL.5\Reporting Services\Report Server\rssrvpolicy.config...".

As we tried to upgrade reporting services using the same administrator account we cannot understand why this error would occur. From checking the version of SQL Server to Reporting Services we have 9.00.1399.06 on SQL Server and 9.00.1399.00 on Reporting Services so I presume this proves the upgrade did not work

Has anyone got any idea what we need to do

Thanks





Re: Upgrading from standard to enterprise edition

Instalectual


I am having this very same error and was curious as to if you were ever able to resolve this issue. Any help would be greatly appreciated.

-Daniel






Re: Upgrading from standard to enterprise edition

Andrew Sears - T4G

You may be able to troubleshoot permission issues with www.sysinternals.com Filemon utility.

cheers,

Andrew







Re: Upgrading from standard to enterprise edition

Instalectual

I resolved the issue so this is for anyone having the same issue. By default the Reporting Services installation location is on the C: drive. When we installed MSSQL originally, we installed it on the D: drive so when it got to the point during the upgrade where it copies the original config files to the upgraded instance it fails since they do not exist in the location it is looking (on the C: drive).

To fix this just change the installation path during the upgrade to your original MSSQL install path (for us it was on D: ) and you should be good to go.

-Daniel





Re: Upgrading from standard to enterprise edition

Kass

Hi

i have the exact same error. i installed on the D drive & also changed the installation path to point to the D drive & it still came up with the same error. any other suggestions

Kass