Link to home
Start Free TrialLog in
Avatar of ToddRod_Taylor
ToddRod_TaylorFlag for United States of America

asked on

SSRS 2005 Error

I have Windows Server 2003 R2 with SQL Server 2005 Standard installed.  This server also hosts a couple of websites that are not associated with the Default Site in IIS.  I have gone through the Reporting Services Configuration tool and believe everything is correct, but when I browse to http://localhost/reportserver, I receive the following error:

Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable.  Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server.  Please review this log entry to discover what caused this error to occur.


When looking at the Event Viewer, I find the following 2 errors:
Source: MSSQLSERVER
Type: Failure Audit
Desc: Login failed for user 'MYDOMAIN\Administrator'.

Source: ASP.NET 2.0.50727.0
Type: Error
Desc: It is not possible to run two different versions of ASP.NET in the same IIS process.  Please use the IIS Administration Tool to reconfigure your server to run the application in a separate process.


How do I go about fixing these errors and getting SSRS up and running?
Thanks for the help!
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ToddRod_Taylor

ASKER

That did get the server back up and running.  I was curious why only my other site or SSRS would work every time I restarted IIS, and that was the problem.  Now when I browse to http://sql/ReportServer (the server name is SQL), I get a directory listing (screen shot attached).  I haven't worked with SSRS 2005 before, I'm more familiar with 2008, so that is not what I expected to see.  Shouldn't I be accessing an admin type interface from that address?  If so, what do you think the problem is now?

Thanks!
Capture.PNG
you need to access it by: http://localhost/ReportManager and NOT Report Server as Report MAnager is the "admin" website.

Also from a client computer you better use the IP of the SSRS server and port if your website is not on the default.
That URL gives me a 404 error.
Not sure why I didn't check this url last week, but http://sql/reports is the site I was looking for.

Thanks.