SSL Configuration - Internet Access - Charts

I have a single SQL report server that uses SSL for reports, and anonymous
and basic authentication turned on. The report server is behind ISA 2004.

Issue 1: I want to provide the following access:

1. Publish a set of statisitcal reports for anonymous access from a website.
2. Publish a set of restricted reports on a WSS site that require a logon.
3. Be able to administer the site from the web.

What are the configuration requirements to achieve this access? I always get
prompted from the web for a logon.

Issue 2: The reports run in development mode, and on the local production
network. When accessed over the internet the report manager displays the
list of reports, but the reports fail with the following error message:
Action Cancelled. IE unable to link to the web page. Is there a
configuration needed in ISA or what else might be needed?

Issue 3: The charts fail to display in production mode. Any tips or ideas on
how to correct this problem?

Thanks.

Dan

v-mingqc
Thu Aug 04 04:08:34 CDT 2005

Hi Dan,

Thanks for your post.

To ensure the integrity of newsgroup and let others benefit from your
thread, we recommand you posting one question per thread, which will also
let us trace the question better. Thank you for your patience and
cooperation in advance.

From your descriptions, I understood you would like to know how to access
the web page with anonymous access via ISA. If I have misunderstood your
concern, please feel free to point it out.

>> 1. Publish a set of statisitcal reports for anonymous access from a
website.

The Report Server itself does not authenticate the user. Instead, it
obtains the user identity from IIS. When Anonymous is enabled, all requests
to the Report Server will come in under the IUSR_<computer name> account or
whatever account you use for Anonymous access. Therefore, the Report Server
cannot differentiate the users.

>> 2. Publish a set of restricted reports on a WSS site that require a
logon.

Would you please help explain restricted reports further? Due to the
different login information? Are you going to integrate WSS with Reporting
Services? The following MSDN Online article might help.

Using Forms Authentication in Reporting Services
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/ufairs.asp?frame=true

>> 3. Be able to administer the site from the web.

If you are accessing via Internet and you want to be the administrator of
site, there is no good way but assign Admin to IUSER in IIS, which is
strongly NOT recommanded.



Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Dan
Thu Aug 04 11:43:58 CDT 2005

Thanks for the response. The issue revolves around the authentication. I
find that if I enable annonymous logon, then none of the roles other than
annonymous are functional. Is there anyway to have it multiple ways? Can I
set up multiple instances of reportservices to have different
authentication? I have one SQL server. Is a solution to schedule and export
a report to the public folder using mhtml format? Then I can keep the
authentication for roles.

For WSS, I installed SP2 and will review the deployment of webparts.

Dan

"Michael Cheng [MSFT]" <v-mingqc@online.microsoft.com> wrote in message
news:2yQWgQNmFHA.944@TK2MSFTNGXA01.phx.gbl...
> Hi Dan,
>
> Thanks for your post.
>
> To ensure the integrity of newsgroup and let others benefit from your
> thread, we recommand you posting one question per thread, which will also
> let us trace the question better. Thank you for your patience and
> cooperation in advance.
>
> From your descriptions, I understood you would like to know how to access
> the web page with anonymous access via ISA. If I have misunderstood your
> concern, please feel free to point it out.
>
>>> 1. Publish a set of statisitcal reports for anonymous access from a
> website.
>
> The Report Server itself does not authenticate the user. Instead, it
> obtains the user identity from IIS. When Anonymous is enabled, all
> requests
> to the Report Server will come in under the IUSR_<computer name> account
> or
> whatever account you use for Anonymous access. Therefore, the Report
> Server
> cannot differentiate the users.
>
>>> 2. Publish a set of restricted reports on a WSS site that require a
> logon.
>
> Would you please help explain restricted reports further? Due to the
> different login information? Are you going to integrate WSS with Reporting
> Services? The following MSDN Online article might help.
>
> Using Forms Authentication in Reporting Services
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
> l/ufairs.asp?frame=true
>
>>> 3. Be able to administer the site from the web.
>
> If you are accessing via Internet and you want to be the administrator of
> site, there is no good way but assign Admin to IUSER in IIS, which is
> strongly NOT recommanded.
>
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
>
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
>
> If you are outside the United States, please visit our International
> Support page: http://support.microsoft.com/common/international.aspx
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

v-mingqc
Fri Aug 05 02:27:34 CDT 2005

Hi Dan,

>> Is a solution to schedule and export a report to the public folder using
mhtml format?

You may use Subscriptions to do this job. Schedule your time and generate
standard subscriptions. For more information, please refer the MSDN online
article below for more informaiton

Subscription Overview
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/
rms_subscribing_v1_70j8.asp


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.