Reporting Services 2000 & 2005 on same machine

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • rmk

    Reporting Services 2000 & 2005 on same machine

    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$RMK00620 05 web site and the ReportsServer$R MK0052006
    configured to ASP.NET 2.0

    Entering http://localhost/reports$rmk0062 005 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. (rsReportServer Disabled) 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. (rsReportServer Disabled) 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\Micr osoft.NET\Frame work\v2.0.50727 \aspnet_regiis. exe -u
    - uninstall 2000 Reporting Services
    - run C:\WINDOWS\Micr osoft.NET\Frame work\v1.1.4322\ aspnet_regiis.e xe -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 !!!!!




Working...