A report may not display a graph or an embedded logo image, SQL Server 2000 Reporting Services may no longer work, and you may receive an error message in Visual Studio 2005 (907665)


The information in this article applies to:

  • Microsoft SQL Server 2000 Reporting Services Service Pack 2
  • Microsoft Visual Studio 2005 Standard Edition
  • Microsoft .NET Framework 2.0

SYMPTOMS

In Microsoft Visual Studio 2005, when you try to view a report by using ReportViewer and the report contains a graph and an embedded logo image, the report may not display the graph or the embedded logo image. Additionally, Microsoft SQL Server 2000 Reporting Services may no longer work. When you run Visual Studio 2005 on a Microsoft Windows XP-based computer, you may receive the following error message:
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 and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help Bad Data.
On other Windows-based servers, you may receive an error message that is similar to the following:
Key not valid for use in specified state.
This problem may occur when any one of the following conditions is true:
  • You perform a side-by-side installation of SQL Server 2005 Reporting Services when SQL Server 2000 Reporting Services is running on Microsoft Internet Information Services (IIS) 5.0.
  • You install the Microsoft .NET Framework 2.0 and then register Microsoft ASP.NET 2.0 on the host computer.

CAUSE

This problem occurs because the ASPNET account password is reset when you install the .NET Framework 2.0 together with Visual Studio 2005.

WORKAROUND

To work around this problem, you must update the SQL Server 2000 version of SQL Server Reporting Services. To do this, follow these steps after you install SQL Server 2005 Reporting Services::
  1. Locate and then delete the 1aedd7b5699f3d6a88e354100b596aae* file. This file is located in a subfolder of the following folder:

    Drive:\Documents and Settings\UserName\Application Data\Microsoft\Crypto\RSA\

    The 1aedd7b5699f3d6a88e354100b596aae* file may be located in an SID folder.
  2. At a command prompt, type the following command, and then press ENTER:

    RSActivate -r -c rsreportserver.config

    Note You must specify the SQL Server 2000 Reporting Services Rsreportserver.config file.

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