Posted by usenetlex on 08/03/06 21:40

Look at the options for aspnet_regiis; you want to run the 2.0 version
with -i to make it the default, then run the 1.1 version again but use
the command line options to change just the web folder for SQL 2000
Reporting Services.

rmk wrote:
> 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]