I've installed CellSetGrid project on my PC (with NET framework 2.0),
then i've added CellSetGrid.dll as a toolbox item in a web site
project.

I've dropped CellSetGrid control in a blank default.aspx page
I ' ve added following connectionstring and cube name in the connection
section of control properties, to connect Analysis Service 2005:

ConnectTo=9.0; Provider=MSOLAP.3;username= "NERVIANOMS\gogligi0" and
pwd= "XXXXXXX";Integrated Security=SSPI;
Persist Security Info=True;Data Source=NERAPPS17;Initial
Catalog=NtsCube_24Aug2006

I receive from IE 6.0 an error message simply saying "error" and
control remains empty.

Can enyone help me ?

Thanks in advance
GG

you can't use a login/password in a connectionstring until you use the HTTP
XML/A access.
only windows authentication can be used for a direct access to the server.
so the username & pwd are not required.

if your web application use the impersonation (in the <identity> tag of the
web.config file) then the logged user account will be used to access the
cube
if the impersonation is disabled, then the identity of the IIS application
pool will be used (or the login name / pwd specified in the <identity> tag)

if you use 2 servers (1 for IIS 1 for SSAS) and you want to use the windows
NT account to authenticate the user, then you have to use an active
directory and the kerberos delegation.
else you can use the basic authentication instead of the NTLM
authentication.

searcj on the MS web site for "Kerberos IIS" and you'll have some procedures
and details.

"gogliogi" <gianluigi.goglio (AT) nervianoms (DOT) com> wrote

Jéjé ha scritto:


I used string
Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security
Info=False;Data Source=NERAPPS17
without username/password
and it seems to work (by the way, I use 1 server for IIS and SSAS),

but now it appears message which says "Cube 'Gfs' does not exist"
Gfs is My cube name
I wrote "Gfs" as cube name in the connection section of the control
properties.
What's wrong ?
I use same domain user to access cube within SSAS.

Thanks
GG

have you defiend a role in the dtabase and associated some users in the
membership?
(and also give access to the GFS cube through this role)

"gogliogi" <gianluigi.goglio (AT) nervianoms (DOT) com> wrote

Jéjé ha scritto:


I used string
Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security
Info=False;Data Source=NERAPPS17
without username/password
and it seems to work (by the way, I use 1 server for IIS and SSAS),

but now it appears message which says "Cube 'Gfs' does not exist"
Gfs is My cube name
I wrote "Gfs" as cube name in the connection section of the control
properties.
What's wrong ?
I use same domain user to access cube within SSAS.

Thanks
GG

Correct,

I defined an "Users" role with access to the cube including
Domain Users
Authenticated Users
Everyone
and the new domain group for group Anonymous Logon.

(At present my IIS is configured to accept windows Authentication, not
anonimous).

what i saw is that I'am able to open CellSetGrid from IE browser, if I
open it from the same machine where IIS and SSAS are.
I can't do it using IE on other PCs including the mine one.


How to configure it to open CellSetGrid in IE browser from every PC in
my domain ?
Thanks again for your help
Gianluigi

Jéjé ha scritto:

ok,
does the target URL is in the "Local intranet" list of IE?

verify that the account used to run the IIS application pool is authorized
to delegate the active user. (using the local group policies)

in the locale group policy (gpedit.msc)
under the Computer > Windows > Security settings > Local Policies > user
rights assignment
verify if the account used for the application pool is under these options:
Act as part of the OS
Impersonate a client after authentication

test the application by ising the Basic authentication, if the basic
authentication works fine, then the NTLM authentication should works too.
Specially if both IIS and AS are on the same server.



"gogliogi" <gianluigi.goglio (AT) nervianoms (DOT) com> wrote

Correct,

I defined an "Users" role with access to the cube including
Domain Users
Authenticated Users
Everyone
and the new domain group for group Anonymous Logon.

(At present my IIS is configured to accept windows Authentication, not
anonimous).

what i saw is that I'am able to open CellSetGrid from IE browser, if I
open it from the same machine where IIS and SSAS are.
I can't do it using IE on other PCs including the mine one.


How to configure it to open CellSetGrid in IE browser from every PC in
my domain ?
Thanks again for your help
Gianluigi

Jéjé ha scritto: