I am trying to install Reporting Services on a Windows 2003 machine which also has SQL Server 2000

Configuration
Window Enterprise 2003 : Application Server and File Server
IIS 6 ; SQL Server 2000 SP3a
Reporting Services SP1 ; ASP.NET_1.1.4322

Because of an issue with SQL Server SP4, on installing RS error 25619 is generated, so following the procedure of Article ID 867872

SETUP.EXE /i "REPORTING_SERVICES\DEV\SETUP\Rsrun.msi" rsdonotcreatevirtualdirectories=true

The SQL Server databases have been created successfully.

Symptoms
I am unable to get the Report Manager to communicate with the Reporting Service, in the event log "Report Manager cannot connect to the ReportServer service. Event ID: 114"
The Report Manager delays for a few seconds and then attempts to display a web page but is prevented someway by then displaying the error message:

The request failed with HTTP status 404: Not Found.

I have found it exceptionally confusing what accounts should be assigned to what service and what the permissions for the folders should be.

Any assistance on this would be very much appreciated.

I've seen similar problems that are typically resolved by uninstalling and reinstalling Reporting Services. It's also possible that a web folder wasn't created correctly. After completely uninstalling RS, look for and remove any left over web folders and then restart IIS before you reinstall. Check all related services (SQLSVR, SQLAgent, SSRS) to make sure they're running and make sure you have used accounts with sufficient permissions. As a test, you can specify an elevated account during setup (like Administrator) and then change this later.

Paul

Paul Turley, MCSD, MCDBA, MCT, MSF Practitioner

I had the same issue installing Reporting Services 2000 Standard on my Win2K3 SP1 + SQL 2000 SP4 box. I followed the instructions outlined in this MS document (http://support.microsoft.com/?id=867872). Unfortunately, the instructions falter in steps L,M,N,O, and P in the IIS 6 section. This section discusses the Report Server virtual directory in the default web in IIS. That step should read
"In the Wildcard application maps section of Application Configuration dialog box, click Insert.... Then browse to the DLL (C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspn et_isapi.dll) and then click OK." You can then click OK your way out of the dialog boxes. Once I did that, Reporting Services worked OK and I was able to go on and install MOM Reporting Server. I hope this helps.

-Hisham