RE: Cube Roles doesn't work with HTTP Connection

#1

You might want to check your IIS security settings.

The MSDN article
"Improved Web Connectivity in Microsoft SQL Server 2000 Analysis Services"
includes a detailed discussion of possible scenarios, under the "IIS and
security" title.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"HÃ©lio SÃ¡ Moreira" wrote:

Quote:

Hi,

IÂ´m trying to implement an OWC based-system over Internet, and I need to
connect OWC control to SQL Server Analysis Services 2000 SP3 ..... I connect,
but my custom cube roles dosen't restrict data.

OWC connection string contains this Analysis Services connection string:
Provider=MSOLAP.2;Data Source=http://local/OLAP/;Initial
Catalog=Ecurso;Client Cache Size=25;Auto Synch Period=10000; User
ID=kasolution\heliom; Password=olappass;

Cube Role restrict a Partner Dimension to kasolution\heliom, but when its
connect he can view all members (and no only one.)

Please help.

Thanks!!!

HÃ©lio SÃ¡ Moreira

#2

Is kasolution\heliom in the OLAP Administrators local machine group or are
they a machine administrator? If so, then they always see all data;
regardless of the security settings.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Hélio Sá Moreira" <HlioSMoreira (AT) discussions (DOT) microsoft.com> wrote

Quote:

Thanks Brian!!! I´ll read this article.

You already it implemented this architecture? with these functionalities?

Best Regards,

Hélio Sá Moreira

"Brian Altmann" wrote:

You might want to check your IIS security settings.

The MSDN article
"Improved Web Connectivity in Microsoft SQL Server 2000 Analysis
Services"
includes a detailed discussion of possible scenarios, under the "IIS and
security" title.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"Hélio Sá Moreira" wrote:

Hi,

I´m trying to implement an OWC based-system over Internet, and I need
to
connect OWC control to SQL Server Analysis Services 2000 SP3 ..... I
connect,
but my custom cube roles dosen't restrict data.

OWC connection string contains this Analysis Services connection
string:
Provider=MSOLAP.2;Data Source=http://local/OLAP/;Initial
Catalog=Ecurso;Client Cache Size=25;Auto Synch Period=10000; User
ID=kasolution\heliom; Password=olappass;

Cube Role restrict a Partner Dimension to kasolution\heliom, but when
its
connect he can view all members (and no only one.)

Please help.

Thanks!!!

Hélio Sá Moreira

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: Cube Roles doesn't work with HTTP Connection

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

RE: Cube Roles doesn't work with HTTP Connection - 11-09-2004 , 01:53 PM

Re: Cube Roles doesn't work with HTTP Connection - 11-09-2004 , 05:32 PM