大网数据广告活动
数据库与应用安全

Error message when Report Server service starts

· 52CE 我爱测

This article helps you resolve the problem that occurs when you reset Report Server service account.

This article helps you resolve the problem that occurs when you reset Report Server service account.

Original product version:   SQL Server
Original KB number:   955757

Symptoms

When you work with a computer that is running Microsoft SQL Server, you may receive the following error message in the Report Server service trace log:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)

You may receive this error message when one of the following actions occurs:

  • The Report Server service starts.
  • You try to access the Reporting Services Web site.

Additionally, you may receive the following error message in the Report Server service trace log:

ERROR: Exception caught while starting service.

Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information.

Cause

Typically, this problem occurs when the Report Server service account password is reset.

Resolution

To resolve this problem, use one of the following methods.

Method 1: Restore the symmetric key

Note: To use this method, you must have a backup copy of the symmetric key available.

To restore the symmetric key, follow these steps:

  1. Start the Reporting Services Configuration tool, and then connect to the report server that you want to configure.
  2. On the Encryption Keys page, click Restore.
  3. Click the .snk file that contains the Backup copy.
  4. Type the password that unlocks the file.
  5. Click OK.

Method 2: Delete the encrypted content

Important: This method deletes all the encrypted content. This includes connection strings and stored credentials. Then, this method creates a new symmetric key. Only use this method if you cannot restore the symmetric key.

After you delete the encrypted content, you must reenter the missing connection strings and the missing stored credentials in the reports and in the shared data sources that no longer have these values. Additionally, you must update all the subscriptions that use delivery extensions that store encrypted data. This includes the file share delivery extension and any third-party delivery extension that uses encrypted values.

There is no automated way to update this information. You must update each report, each subscription, and each shared data source that uses stored credentials and connection strings one at a time.

To delete the encrypted content, follow these steps:

  1. Start the Reporting Services Configuration tool, and then connect to the report server that you want to configure.
  2. On the Encryption Keys page, click Delete encrypted content.

References

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 09/21/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。