I am coming across a particularly frustrating little error...I've scoured the internet and have yet to find an answer which works for me.
I have installed SQL Server 2000 Reporting Services and have gotten it to work. When my webservice was set to http://localhost
, all was well on my machine...and other machines would get broken links.
So I moved the webservice to a dynamic location. And now I cannot bring up SQL Reporting Services in my .aspx page. (Viewing them through Report Manager still displays accurately on my screen, but not through an IIS webpage) I get this error:
The permissions granted to user "<server>"\ASPNET" are insufficient for performing this operation.
The permissions granted to user "<server>"\IUSR_<username>
" are insufficient for performing this operation.
(the 2nd appears when I include <identity impersonate="true" /> in my web.config)
I have seen a lot of talk about adding the user to Report Manager...I added the following accounts to Home, and gave them full access:
BUILTIN\Administrators (this one was already there)
Each of these accounts has full access, and I still get the error message.
Any ideas? I have Integrated Windows Authentication set on my virtual directories...I tried anonymous access as well, and I got the same message (with the IUSR_ account specified).
At this point, I'm fried. Anybody have any answers? Thanks.