|
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 !!!!!
Navigation:
[Reply to this message]
|