Posted by rmk on 07/11/06 15:36

How can I get the 2000 and 2005 versions of SQL Server Reporting Services
both working on my development laptop ?????

I have ASP.NET 1.1 and 2.0 installed on my laptop.

I have Visual Studio 2003 and 2005 installed on my laptop.

I have my default website configured for ASP.NET 2.0.

I have the developer edition of SQL Server 2000 installed on my laptop as
instance RMK006 in the MSSQL folder. I have the developer edition of SQL
Server installed on my laptop as instance RMK0062005 in the MSSQL.1 folder.
I have the corresponding versions of SQL Server Reporting Services installed
on my laptop.

I have the Reports web site and the Reports web site and ReportServer web
site configured to ASP.NET 1.1

I have the Report$RMK0062005 web site and the ReportsServer$RMK0052006
configured to ASP.NET 2.0

Entering http://localhost/reports$rmk0062005 in my web browser works fine.

Entering http://localhost/reportserver in my web browser generates the
following error:
Reporting Services Error
--------------------------------------------------------------------------------

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.

--------------------------------------------------------------------------------
Microsoft Reporting Services

Entering http://localhost/Reports in my web browser generates the following
error:

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.

The only way I can seem to get 2000 Reporting Services working is to do the
following:

- run C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -u
- uninstall 2000 Reporting Services
- run C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
- install 2000 Reporting Services

But once I've done that Visual Studio 2005 etc no longer work.

The utlimate goal is an ASP.NET 2.0 application developed in Visual Studio
2005; the application is based on a SQL Server 2000 database and needs to
invoke SQL Server 2000 Reporting Services to run reports.

What am I doing wrong?

ANY HELP WOULD BE GREATLY APPRECIATED - I'M DIEING HERE AND MY CLIENT IS
LOSING PATIENCE !!!!!

[Back to original message]