URL access for reports

Question

Post reply

URL access for reports

Vishal Singh

SSCertifiable

Points: 5830
More actions
November 29, 2010 at 1:58 am

#388321

this KB is stating that the reports can be accessed through direct URL by a web application:
http://msdn.microsoft.com/en-us/library/ms155362(v=SQL.100).aspx
When I am trying to use this i.e. I embedded the direct URL for reports in one of my ASP.NET web application and tried opening the reports it was complaining about the permission to the windows user.
My report server is in Native mode.
Can somebody highlight what I am missing here...
-Forum Etiquette: How to post Performance Problems[/url]
-Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

How are you trying to access the reports in ASP .NET? (Direct URL or reportviewer control)?

What is the authentication mode of the users on the site?

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 2

Ninja's_RGR'us (11/29/2010)
How are you trying to access the reports in ASP .NET? (Direct URL or reportviewer control)?
What is the authentication mode of the users on the site?

I want to keep it to direct URL

If you are asking Authentication mode on Report Server URL then its windows. I Can change it if need be..

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

I've never done it that way (not even sure it's possible).

Assuming the address looks something like this :

http://reportServer/reports/...

How is someone going to be able to resolve that name? He needs to be windows authenticated on the network to be able to resolve it.

I'm not strong enough in networking to tell you if you can expose it on the internet somehow with ip/port forwarding... but I would be a little bit surprised if you found a way.

When I did it in a public asp .net web site I had tu use a reportviewer control.

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 4

Ninja's_RGR'us (11/29/2010)
I've never done it that way (not even sure it's possible).
Assuming the address looks something like this :
http://reportServer/reports/...
How is someone going to be able to resolve that name? He needs to be windows authenticated on the network to be able to resolve it.
I'm not strong enough in networking to tell you if you can expose it on the internet somehow with ip/port forwarding... but I would be a little bit surprised if you found a way.
When I did it in a public asp .net web site I had tu use a reportviewer control.

I understand. Can you shed some light on how to use ReportViewer control and how the authentication to be made using this control..

I am not a .NET guy but will learn and try doing it in .NET.

Thanks in advance.

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

I got all my info from this site :

http://www.gotreportviewer.com/

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 6

Ninja's_RGR'us (11/29/2010)
I got all my info from this site :
http://www.gotreportviewer.com/

Ok. I am gonna try this to see if I can do with it..

Thanks for sharing this information.

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 7

with Report viewer, the problem I am currently facing is that if I give it a server name and report path, its working fine for the user who had explicitly granted the permission 'browser' on Report Manager..but its not working for them who do not have this permission.

For an application in web environment, this wont work as everytime people try browsing the reports (which really hard to say from which domain which user etc..) to add everybody on report manager...

Is there anything I am missing to bind the credentials to ReportViewer..?

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 8

Yes you can set a default for all users. The only downside is that you have to control the permissions manually from ASP rather than active directory.

http://social.msdn.microsoft.com/forums/en-US/vsreportcontrols/thread/c65abca7-0fdb-40fb-aabe-718f63377a55/