Anonymous access...

I want my report be accessible for everybody. So i enable anonymous access
(IUSR_MACHINE) on the virtual site ReportServer.
On my report, i allow IUSR_MACHINE the Browser Role.
Administrators have all Role on my report.
When i want to acces to the admin page (http://localhost/Reports), I have a
window authentification (like I want), I put my Admin login and pass but I
have not the Administrators rigth. I can only see what the IUSR_MACHINE as
right.
When I disable anonymous acces on ReportServer, I can see everything.
Can you help me 'Karine,
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.
Since you will need to manage the Report Server you will need to elevate
IUSR permissions in RS or assign it to a Windows group which has management
rights. Both approaches are equally bad from security standpoint and a sure
invitation for a security hack. Besides, Anonymous access is not officially
supported.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Karine" <Karine@.discussions.microsoft.com> wrote in message
news:49C55288-1B45-44BB-870D-CBDF84420D72@.microsoft.com...
> I want my report be accessible for everybody. So i enable anonymous access
> (IUSR_MACHINE) on the virtual site ReportServer.
> On my report, i allow IUSR_MACHINE the Browser Role.
> Administrators have all Role on my report.
> When i want to acces to the admin page (http://localhost/Reports), I have
a
> window authentification (like I want), I put my Admin login and pass but I
> have not the Administrators rigth. I can only see what the IUSR_MACHINE as
> right.
> When I disable anonymous acces on ReportServer, I can see everything.
> Can you help me '
>
>
>

Analysis services connection from Data Source

Hello everybody.

I want to perform a Analysis Services Processing Task using a connection manager created from a Analysis Services data source. I create the data source using the Oledb provider for Analysis Services 9.0, and it works fine. Then I create a connection manager using the "New connection from data source" option, and it seems to create it ok.

The problem is that I can't then asign this connection to the Analysis Services processing task. I get the error:

"Connection Manager MyConectionManagerFromDataSource is not a Analysis Services Connection Manager"

However, if I create directly a connection manager using "New Analysis Services Connection" it works fine.

Is it at all possible to create a Analysis services connection from a Data Source to perform a Analysis Services Processing Task?

Thanks in advance,

Check the two Connection Manager that you have created. There must be some difference between them.

-Jamie

|||

Thanks Jamie.

I've been checking the connection strings, and there is a slight difference:

Analysis services connection manager:

Data Source=myserver;Initial Catalog=mycatalog;Provider=MSOLAP.3;Integrated Security=SSPI;Impersonation Level=Impersonate;

Connection manager from data source:
Provider=MSOLAP.3;Data Source=myserver;Integrated Security=SSPI;Initial Catalog=mycatalog;Impersonation Level=3

I've tried to change the Impersonation Level to Impersonate in the Data Source, but only integer values are alowed.

Also, in the connection manager type, I have MSOLAP90 for the AS connection manager, and OLEDB for the CM from Data source. I think this must be the issue, but I'm not able to change the connection manager type

Thanks again,