Microsoft KB Archive/907367

= You receive a &quot;Failure modifying security permissions&quot; error message when you try to install SQL Server 2000 Reporting Services SP2 =

Article ID: 907367

Article Last Modified on 3/14/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Reporting Services Service Pack 2

-





SYMPTOMS
When you try to install Microsoft SQL Server 2000 Reporting Services Service Pack 2 (SP2) on a computer on which Microsoft SQL Server 2000 and Microsoft SQL Server 2000 Reporting Services Service Pack 1 are installed, you may receive an error message that is similar to the following:

Failure modifying security permissions on file c:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles for user

This issue may occur if the ReportServer service is running under a domain user account identity.



WORKAROUND
To work around this issue, follow these steps:

Note When you change the account that is used by the ReportServer service, the encryption keys for the ReportServer service are also changed. For more information about how to back up and restore the encryption keys for the ReportServer service, see the &quot;More Information&quot; section.  Back up the encryption keys for the ReportServer service by using the rskeymgmt utility. To do this, use the following command:

rskeymgmt -e -f c:\rsdbkey.snk -p

 Click Start, click Run, type Services.msc, and then click OK. Right-click ReportServer, and then click Properties. On the Log On tab, click LocalSystem account, and then click OK.

Note the user account under which the ReportServer service is currently running. Right-click ReportServer, and then click Stop. Install SQL Server 2000 Reporting Services SP2. Right-click ReportServer, and then click Properties.</li> On the Log On tab, click This account, type the user name and the password that you noted in step 3, and then click OK.</li> Restore the ReportServer service encryption keys by using the rskeymgmt utility. To do this, use the following command:

rskeymgmt -a -f c:\rsdbkey.snk -p

</li> Restart the server.</li></ol>

<div class="status_section">

STATUS
<div class="notice_section">

Warning This information is preliminary and has not been confirmed or tested by Microsoft. Use only with discretion.

<div class="moreinformation_section">

MORE INFORMATION
For more information about how to back up and restore the encryption keys for the ReportServer service, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/aa972238(SQL.80).aspx

http://msdn2.microsoft.com/en-us/library/ms157275.aspx

Keywords: kbtshoot kbprb KB907367

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.