Groups | Blog | Home
all groups > sql server reporting services > july 2006 >

sql server reporting services : Authentication issue with report called from VB.Net application


Kevin O'Donovan
7/25/2006 5:07:23 PM
Hi,
I've written an application in VB.Net 2005. One of its requirements is to
display a report which is hosted on our report server, and to let people
subscribe to this report (to get a copy once a week by email, for example).
To do this I have created a windows form containing a web browser control,
and set the URL of that control to the URL of the report, which happens to
be:

http://10.9.200.18/Reports/Pages/Report.aspx?ItemPath=%2fBunker+Management+Reports%2fActive+Bunker+Schemes+Due+To+Expire

Whenever I open that form I get prompted for my windows credentials. Also,
if I go straight to that URL in a web browser, I also get prompted for my
credentials. However, if I start from

http://10.9.200.18/Reports I can navigate to the same report without being
prompted for my credentials.

What can I do to be able to jump straight to the report without being
prompted for credentials? I switched on the option to enable anonymous
access for the web site itself (this is an internal web server), which did
the trick, but then I couldn't access the report server via either

http://10.9.200.18/Reports - took me to the report server home page, but
didn't list any contents

or

http://10.9.200.18/ReportServer - told me that the anonymous user account
didn't have permission to access the resource.

Enabling anonymous access wasn't exactly ideal, anyway. For one thing it
applied to the whole site, not just the report, and for another the user are
all going to be authenticated users anyway, so...

Kev

Kevin O'Donovan
7/28/2006 12:00:00 AM
[quoted text, click to view]

Okay, solved this ourselves, though if anyone can explain why, I'd be
grateful. When I refer to the web server via its IP address I get prompted
for credentials. When I refer to it by its DNS name I don't get prompted. I
can resolve my immediate problem by using the name in the URL, and adding
that name to the remote user's site's DNS, but I'd like to understand why
the two URLs are treated differently?

Kevin

AddThis Social Bookmark Button