Microsoft KB Archive/907665

= 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 =

Article ID: 907665

Article Last Modified on 12/3/2007

-

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::  Locate and then delete the 1aedd7b5699f3d6a88e354100b596aae* file. This file is located in a subfolder of the following folder:



The 1aedd7b5699f3d6a88e354100b596aae* file may be located in an SID folder. 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.



Additional query words: KBsql2005rs

Keywords: kbtshoot kbprb KB907665

-

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

© Microsoft Corporation. All rights reserved.