Re: Permissions issues sharing access to cubes

#1

"Jim" <no_jimf_spam (AT) cogenix (DOT) com> wrote

Quote:

I've built an OLAP database with two cubes. They work perfectly on my
machine, and I have created an Excel spreadsheet that accesses them
without
any problems. Administrators on the system are able to use the
spreadsheet
without any issues. However, anybody who is not a domain admin is able to
see the database, but when connecting, the cubes aren't there, so the
spreadsheet doesn't work. I've tried creating a Database Role with Domain
Users (even Everyone) as members, and granted full control to Domain Users
to the folders containing the cube data, to no effect.

After you created Database Role, did you grant permissions to the members of
that role to the cubes in question ?

==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

#2

Yes. I checked off access to both cubes, and I tried enforcing roles on
both the server and on the client.

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote

Quote:

"Jim" <no_jimf_spam (AT) cogenix (DOT) com> wrote in message
news:OKmuz$1YDHA.2308 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
I've built an OLAP database with two cubes. They work perfectly on my
machine, and I have created an Excel spreadsheet that accesses them
without
any problems. Administrators on the system are able to use the
spreadsheet
without any issues. However, anybody who is not a domain admin is able
to
see the database, but when connecting, the cubes aren't there, so the
spreadsheet doesn't work. I've tried creating a Database Role with
Domain
Users (even Everyone) as members, and granted full control to Domain
Users
to the folders containing the cube data, to no effect.

After you created Database Role, did you grant permissions to the members
of
that role to the cubes in question ?

==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

#3

"Jim" <jim (AT) xmarksnothing (DOT) com> wrote

Quote:

Yes. I checked off access to both cubes, and I tried enforcing roles on
both the server and on the client.

If you change on the servre registry HKLM\Software\Microsoft\OLAP
Server\CurrentVersion\AuditEvents to 0xF, and then check the NT Event Log -
do you see right user names being logged ?

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

#4

Yes. I get the following two events:
Event ID: 105. Message: User REMOTEBK\jforrest opened connection 0 from
DELL1
Event ID: 106. Message: User REMOTEBK\jforrest closed connection 4 from
DELL1

Thanks for all of your help, Jim

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote

Quote:

"Jim" <jim (AT) xmarksnothing (DOT) com> wrote in message
news:eO%238I9SZDHA.1748 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Yes. I checked off access to both cubes, and I tried enforcing roles on
both the server and on the client.

If you change on the servre registry HKLM\Software\Microsoft\OLAP
Server\CurrentVersion\AuditEvents to 0xF, and then check the NT Event
Log -
do you see right user names being logged ?

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

#5

Yes. I get the following two events:
Event ID: 105. Message: User REMOTEBK\jforrest opened connection 0 from
DELL1
Event ID: 106. Message: User REMOTEBK\jforrest closed connection 4 from
DELL1

Thanks for all of your help, Jim

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote

Quote:

"Jim" <jim (AT) xmarksnothing (DOT) com> wrote in message
news:eO%238I9SZDHA.1748 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Yes. I checked off access to both cubes, and I tried enforcing roles on
both the server and on the client.

If you change on the servre registry HKLM\Software\Microsoft\OLAP
Server\CurrentVersion\AuditEvents to 0xF, and then check the NT Event
Log -
do you see right user names being logged ?

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

#6

"Jim" <no_jimf_spam (AT) cogenix (DOT) com> wrote

Quote:

Yes. I get the following two events:
Event ID: 105. Message: User REMOTEBK\jforrest opened connection 0 from
DELL1
Event ID: 106. Message: User REMOTEBK\jforrest closed connection 4 from
DELL1

OK, so the right user is authenticated, and you enabled the cube roles.
The only issue that can be is that those machines don't have MSOLAP.2
installed, or for some reason MSOLAP.1 became default ProgID for MSOLAP.
Can you try to open MDX Sample from one of those machine, and for provider
specify MSOLAP.2. Do you see the cubes now ?
If yes, run "regsvr32.exe msolap80.dll" and MSOLAP.2 will become default
provider.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

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

Re: Permissions issues sharing access to cubes

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

Re: Permissions issues sharing access to cubes - 08-17-2003 , 12:29 AM

Re: Permissions issues sharing access to cubes - 08-17-2003 , 09:20 PM

Re: Permissions issues sharing access to cubes - 08-18-2003 , 12:17 AM

Re: Permissions issues sharing access to cubes - 08-18-2003 , 01:31 PM

Re: Permissions issues sharing access to cubes - 08-18-2003 , 01:32 PM

Re: Permissions issues sharing access to cubes - 08-18-2003 , 10:29 PM