sql report 2008 and web services

[Aleks Kleyn]

I prepared sql server report 2008 and want to show it in asp page. When
visual studio is opened for project I can open add web service. Puting URL
for report I can see it without problem. It is does not matter i opened VS
as administrator or as regulat user.

To see report on web page I wrote code
<iframe
src="http://localhost/ReportServer/Pages/ReportViewer.aspx?/Vocab/erVocab&rs:Command=Render"
style="width:100%; height:1400" runat="server">
</iframe>

However when I brows report from IIS 7.0 it responds
The permissions granted to user '...' are insufficient for performing this
operation. (rsAccessDenied)

what kind of setting of web page i need to change in order to see report.

thank you.

 

[Munna]

Hi

follow this thread... might help

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1158068&SiteID=1

Best of luck

-----------
Munna

www.munna.shatkotha.com/blog
www.munna.shatkotha.com
www.shatkotha.com

 

[Aleks Kleyn]

Your reference is very useful. However it is reference to sql server 2005
online. Because I have sql server 2008 and windows Vista I read both books
at the same time. At least one recomendation works. Adding local host to
trusted site i can see report in internet explorer when this report is made
on local host. however when I change localhost by name of computer i get the
same error.

of course change on level of IE is not satisfactory. I cannot force user add
the site into trusted zone. I think this change should be done on level IIS.