This is a discussion on Reporting Services 2000 & 2005 on same machine within the SQL Server forums, part of the Microsoft SQL Server category; --> How can I get the 2000 and 2005 versions of SQL Server Reporting Services both working on my development ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 !!!!! |