By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,537 Members | 1,471 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,537 IT Pros & Developers. It's quick & easy.

Reporting Services 2000 & 2005 on same machine

P: n/a
rmk
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\aspn et_regiis.exe -u
- uninstall 2000 Reporting Services
- run C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspne t_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 !!!!!

Jul 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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\aspn et_regiis.exe -u
- uninstall 2000 Reporting Services
- run C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspne t_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 !!!!!
Aug 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.