You receive a "Failure modifying security permissions" error message when you try to install SQL Server 2000 Reporting Services SP2 (907367)


The information in this article 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 "More Information" section.
  1. 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 -ppassword

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

    Note the user account under which the ReportServer service is currently running.
  5. Right-click ReportServer, and then click Stop.
  6. Install SQL Server 2000 Reporting Services SP2.
  7. Right-click ReportServer, and then click Properties.
  8. 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.
  9. Restore the ReportServer service encryption keys by using the rskeymgmt utility. To do this, use the following command:

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

  10. Restart the server.

STATUS

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

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://msdn.microsoft.com/library/en-us/rsadmin/htm/arp_dbadmin_v1_98xh.asp?frame=true

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

Modification Type:MajorLast Reviewed:11/28/2005
Keywords:kbtshoot kbprb KB907367 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.