sql report 2008 and web services

A

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.
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,708
Messages
2,569,346
Members
44,650
Latest member
LuckyVivo

Latest Threads

Top