Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old November 16th, 2005, 12: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

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

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
Reply With Quote
  #3 (permalink)  
Old February 7th, 2007, 05:29 PM
Registered User
 
Join Date: Feb 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 09:08 AM
SQL REPORTING SERVICES PROBLEM ZoroAstris SQL Server 2000 4 January 10th, 2005 03: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



All times are GMT -4. The time now is 02:37 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.