Access a report from the Internet with no authentication

Is it possible to access a report from the Internet (in a non Windows Domain
context) without supplying any credentials. For instance, a user types in
this URL:
http://www.mydomain.com/ReportServer/Pages/ReportViewer.aspx?%2fMyFolder2%2fMyReport
and he/she woulnd not be prompted by a login dialog, and could simply view
the report.

I tried all sorts of different things (stored credentials in the datasource,
impersonating a user, etc.) from both BIDS and Report Manager, but I can't
seem to make it work. BTW, I can read the report just fine if I supply a
user name and password.

Thank you,

--

Alain Quesnel
alainsansspam@logiquel.com

www.logiquel.com

EMartinez
Sat Dec 01 21:56:56 PST 2007

On Dec 1, 4:12 pm, "Alain Quesnel" <alainsanss...@logiquel.com> wrote:
> Is it possible to access a report from the Internet (in a non Windows Domain
> context) without supplying any credentials. For instance, a user types in
> this URL:http://www.mydomain.com/ReportServer/Pages/ReportViewer.aspx?%2fMyFol...
> and he/she woulnd not be prompted by a login dialog, and could simply view
> the report.
>
> I tried all sorts of different things (stored credentials in the datasource,
> impersonating a user, etc.) from both BIDS and Report Manager, but I can't
> seem to make it work. BTW, I can read the report just fine if I supply a
> user name and password.
>
> Thank you,
>
> --
>
> Alain Quesnel
> alainsanss...@logiquel.com
>
> www.logiquel.com


The best option would be to use a report viewer control as part of a
custom ASP.NET application. A less desirable option would be to use
the Reporting Services Web Service to export the report and then allow
the user to view/download the report in that format (i.e., PDF, etc).
This link would help with this option.
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant

Bruce
Mon Dec 03 06:57:37 PST 2007

If you are not doing as Enrique is suggesting (i.e. you have your own app
that is being interfaced to) then you have one very poor possibility.

If you make the web sites (via IIS) anonymous this will work. However, you
will then have NO admin capability because everyone is anonymous. You would
need to switch off anonymous access everytime you want to perform any
administrative work.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Alain Quesnel" <alainsansspam@logiquel.com> wrote in message
news:ehPSPdGNIHA.4480@TK2MSFTNGP06.phx.gbl...
> Is it possible to access a report from the Internet (in a non Windows
> Domain context) without supplying any credentials. For instance, a user
> types in this URL:
> http://www.mydomain.com/ReportServer/Pages/ReportViewer.aspx?%2fMyFolder2%2fMyReport
> and he/she woulnd not be prompted by a login dialog, and could simply view
> the report.
>
> I tried all sorts of different things (stored credentials in the
> datasource, impersonating a user, etc.) from both BIDS and Report Manager,
> but I can't seem to make it work. BTW, I can read the report just fine if
> I supply a user name and password.
>
> Thank you,
>
> --
>
> Alain Quesnel
> alainsansspam@logiquel.com
>
> www.logiquel.com
>
>

Alain
Mon Dec 03 07:15:03 PST 2007

Do you know if this would work with MSSQL 2005 Express running on XP Pro? I
tried setting anonymous access on IIS, and when I try to open a report from
the Internet, I'm prompted with a login that has a greyed-out user name
(MachineName\Guest) and an empty password. I'm trying to get rid of the
login altogether.

--

Alain Quesnel
alainsansspam@logiquel.com

www.logiquel.com


"Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
news:OsbHZzbNIHA.1212@TK2MSFTNGP05.phx.gbl...
> If you are not doing as Enrique is suggesting (i.e. you have your own app
> that is being interfaced to) then you have one very poor possibility.
>
> If you make the web sites (via IIS) anonymous this will work. However, you
> will then have NO admin capability because everyone is anonymous. You
> would need to switch off anonymous access everytime you want to perform
> any administrative work.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Alain Quesnel" <alainsansspam@logiquel.com> wrote in message
> news:ehPSPdGNIHA.4480@TK2MSFTNGP06.phx.gbl...
>> Is it possible to access a report from the Internet (in a non Windows
>> Domain context) without supplying any credentials. For instance, a user
>> types in this URL:
>> http://www.mydomain.com/ReportServer/Pages/ReportViewer.aspx?%2fMyFolder2%2fMyReport
>> and he/she woulnd not be prompted by a login dialog, and could simply
>> view the report.
>>
>> I tried all sorts of different things (stored credentials in the
>> datasource, impersonating a user, etc.) from both BIDS and Report
>> Manager, but I can't seem to make it work. BTW, I can read the report
>> just fine if I supply a user name and password.
>>
>> Thank you,
>>
>> --
>>
>> Alain Quesnel
>> alainsansspam@logiquel.com
>>
>> www.logiquel.com
>>
>>
>
>

Bruce
Mon Dec 03 07:31:51 PST 2007

Sorry, I don't know the answer to that.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Alain Quesnel" <alainsansspam@logiquel.com> wrote in message
news:efA1J9bNIHA.3852@TK2MSFTNGP06.phx.gbl...
> Do you know if this would work with MSSQL 2005 Express running on XP Pro?
> I tried setting anonymous access on IIS, and when I try to open a report
> from the Internet, I'm prompted with a login that has a greyed-out user
> name (MachineName\Guest) and an empty password. I'm trying to get rid of
> the login altogether.
>
> --
>
> Alain Quesnel
> alainsansspam@logiquel.com
>
> www.logiquel.com
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
> news:OsbHZzbNIHA.1212@TK2MSFTNGP05.phx.gbl...
>> If you are not doing as Enrique is suggesting (i.e. you have your own app
>> that is being interfaced to) then you have one very poor possibility.
>>
>> If you make the web sites (via IIS) anonymous this will work. However,
>> you will then have NO admin capability because everyone is anonymous. You
>> would need to switch off anonymous access everytime you want to perform
>> any administrative work.
>>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Alain Quesnel" <alainsansspam@logiquel.com> wrote in message
>> news:ehPSPdGNIHA.4480@TK2MSFTNGP06.phx.gbl...
>>> Is it possible to access a report from the Internet (in a non Windows
>>> Domain context) without supplying any credentials. For instance, a user
>>> types in this URL:
>>> http://www.mydomain.com/ReportServer/Pages/ReportViewer.aspx?%2fMyFolder2%2fMyReport
>>> and he/she woulnd not be prompted by a login dialog, and could simply
>>> view the report.
>>>
>>> I tried all sorts of different things (stored credentials in the
>>> datasource, impersonating a user, etc.) from both BIDS and Report
>>> Manager, but I can't seem to make it work. BTW, I can read the report
>>> just fine if I supply a user name and password.
>>>
>>> Thank you,
>>>
>>> --
>>>
>>> Alain Quesnel
>>> alainsansspam@logiquel.com
>>>
>>> www.logiquel.com
>>>
>>>
>>
>>
>