Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
| Search | Today's Posts | Mark Forums Read
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 16th, 2005, 01:24 PM
Registered User
Join Date: Nov 2005
Location: Rhyl, , United Kingdom.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem with Reporting Services and Windows 2003

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

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.

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.
  #2 (permalink)  
Old November 19th, 2005, 06:16 AM
Wrox Author
Points: 183, Level: 3
Points: 183, Level: 3 Points: 183, Level: 3 Points: 183, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: May 2004
Location: Vancouver, Washington, USA.
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts

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 Turley, MCSD, MCDBA, MCT, MSF Practitioner
  #3 (permalink)  
Old February 7th, 2007, 06:29 PM
Registered User
Join Date: Feb 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

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.


Similar Threads
Thread Thread Starter Forum Replies Last Post
ACCESS 2000 Report problem on Windows 2003 scourge Access 1 April 19th, 2006 05:36 AM
ShowHideToggle Problem in Reporting Services 2005 aldwinenriquez Reporting Services 1 February 15th, 2006 10:08 AM
SQL REPORTING SERVICES PROBLEM ZoroAstris SQL Server 2000 4 January 10th, 2005 04:23 AM
Windows XP ( +access 2003) problem? belete Access 1 October 11th, 2004 09:19 AM
Installing Reporting Services Problem ioates SQL Server 2000 1 June 18th, 2004 09:32 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.