Friday, March 9, 2012

RS on sql server 2000 and 2005 on same machine

Hi Samuel,

I'd like to draw on your expertise on this topic. I've been browsing at many blogs/forums about installing SQL Server 2000 and 2005 on the same machine.

What I'd like to know is how does that work with Reporting Services? Your machine's IIS will need to work with Reporting Services 2000 and Reporting Services 2005. The RS 2005 requires .NET Framework 2.0 and RS 2000 requires .NET Framework 1.1. IIS can only support 1 version of the .NET Framework at a time.

Thanks kindly.

I ran the question by the RS folks and here is the reply:

RS 2005 will run in a separate ASP.Net app pool from RS 2000. In this way, the .Net Frameworks are segregated. To this extent, IIS does support multiple .Net Frameworks versions, just not in the same app pool.

RS 2000
Default app pool
.Net Framework 1.1
Default virtual directories

RS 2005
“ReportServer” or some other user-specified app pool
.Net Framework 2.0
Non-default virtual directories (nominally they will be “ReportServer” and “Reports” appended with “$” plus the instance name, but they can be user-specified also)

Thanks,
Sam Lester (MSFT)

|||Here is another question regarding the problem, i ve installed Reporting Services 2005 on 64-bit machine and when i configure it, it is configured properly but when i tried to access Report Server it asks me for credentials i provide appropriate credentials then it IIS message appears You are not authorized to access this page, secondly when i try to access the Reports it say Page not found. Then i switched the IIS mode from 64-bit to 32-bit and installed .NET Framework 1.1 and 2.0 for 32-bit but same thing is happening again with message when i try to access reports "Internal Server Error". Is there any seperate version for 32-bit and 64-bit of Reporting Services? Please help me in this regard, i am stuck in this matter for too much time now....

No comments:

Post a Comment