?
Solved

sql server 2005 reporting services installation problems

Posted on 2008-10-05
6
Medium Priority
?
785 Views
Last Modified: 2009-01-11
Installing SQL Server 2005 Reporting Services on Vista Ultimate is hell. At least that is my experience after hours and hours at it.

Currently, I am trying to figure out why nothing works/displays in the browser. If I select my reporting manager directory within IIS 7 and click on Basic Settings/Test Settings I get the error listed at the end of this message. The same for the virtual directory for the reportServer.

Within IIS if I right click on each of the directories and edit permission I can see that I have given full control to for the username myComputer/ReportServer2005 for both directories. The Reporting Services Configuration application shows that the windows service identity is Service Account myComputer/ReportServer2005 and the Windows Account option is checked. The web services are running under the DefaultAppPool.

If I enter URL http://myComputer/Reports/ I get a page of stuff but the main message is that 'the request is not available in this context'. Checking the event log shows an event code of Event code: 3005, Event message: An unhandled exception has occurred' and :

Process information:
    Process ID: 8008
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: HttpException
    Exception message: Request is not available in this context
 
Request information:
    Request URL: http://rprice-laptop/Reports/home.aspx 
    Request path: /Reports/home.aspx

If I try URL http://myComputer/Reports/ I get a web application on this server is unavailable, nothing in the event log and no real indication of what is wrong.

The server is configured to use pass-through authentication with a built-in account to access the specified physical path. However, IIS Manager cannot verify whether the built-in account has access. Make sure that the application pool identity has Read access to the physical path. If this server is joined to a domain, and the application pool identity is NetworkService or LocalSystem, verify that <domain>\<computer_name>$ has Read access to the physical path. Then test these settings again.
0
Comment
Question by:blindbull
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 22646322
I remember having this issue when I installed on vista.
Have you enabled II6 compatability?
http://support.microsoft.com/kb/934164


0
 
LVL 1

Accepted Solution

by:
rwinkler earned 1000 total points
ID: 22899554
A friend of mine was looking for a solution to this.  It appears as though she found it.  Here it is:
Use an app pool that is in classic mode instead of integrated mode.

0
 
LVL 29

Expert Comment

by:QPR
ID: 22899688
I believe enabling II6 compatability enables you to specify this on the app pool.
0
 

Author Comment

by:blindbull
ID: 23035067
The book that I am using states that you should not use an App Pool in Classic Mode when developing reporting services in .NET
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 1000 total points
ID: 23038786
Did you check this link?
http://support.microsoft.com/kb/934164
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question