I am using Reporting Services to show reports in a Inventory Control asp.net
web app. So that users do not have to log into a windows account when they
want to see a report, I mapped the anonymous user to the windows user
"RSUser" (as in "Reporting Services User") in IIS. That way whoever uses the
web app is automatically logged in as RSUser.
This works well until we decided to use Report Manager as our reporting app
that will work together with the Inventory Control app. We wanted to be able
let users log in as themselves and have different access depending on who
they were, but they were automatically logged in as RSUser by IIS.
So, in IIS, I copied the 2 virtual directories that reporting services use
(Reports and ReportServer) from the Default Web Site to the Inventory Control
web site (both in IIS, on the same server). Both sets of virtual directories
are the same and point to the same actual directory (i.e. C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer). The
difference is that one under the default website does not allow anonymous
access (and so will prompt the user to login), and the other is under
Inventory Control web site and will automatically log the user in as RSUser.
Problem is : http://[Inventory Control Website]/ReportServer doesn't work.
you get "permission denied". If you allow directory browsing, you see the
files within the directory, not the report. it is as if reporting services
can't render a report if it is not accessed via the default virtual directory
(could this be so ?).
Any idea why this doesn't work or any better suggestions ?