dbTalk Databases Forums  

Is this possible?

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


Discuss Is this possible? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris
 
Posts: n/a

Default Is this possible? - 09-18-2006 , 01:34 PM






Hi,
Users on my Domain are able to access OLAP cubes via excel, but those not on
domain (users with laptops) are unable to. I see there is an Option in excel,
while setting up the connection to OLAP Server, is to access the cube via
http and iis. Is this possible? If so, where can I find information in
getting iis to connect to the OLAP server?

I am using MSAS 2000.

Thanks

Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Is this possible? - 09-18-2006 , 01:47 PM






AS2000 enterprise edition can be accessed through HTTP connections (look at
the msolap.asp file from the enterprise edition CD rom or installation)

also, you can try this:
connect a shared folder on the AS server from the non-domain station, then
open the cube.
you can be authenticated using this procedure.

"Chris" <Chris (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,
Users on my Domain are able to access OLAP cubes via excel, but those not
on
domain (users with laptops) are unable to. I see there is an Option in
excel,
while setting up the connection to OLAP Server, is to access the cube via
http and iis. Is this possible? If so, where can I find information in
getting iis to connect to the OLAP server?

I am using MSAS 2000.

Thanks



Reply With Quote
  #3  
Old   
Tiago Rente
 
Posts: n/a

Default Re: Is this possible? - 09-21-2006 , 12:16 PM



What I do is open a shared folder on the server the cube is in, fill in the
credencials with a domain login and save password.

If you do not have access to a shared folder you can do the same using "net
use" and create a persistent connection to the server. The difference is that
if no shared folder is available you can use the "<server name>\ipc$".

"Jéjé" wrote:

Quote:
AS2000 enterprise edition can be accessed through HTTP connections (look at
the msolap.asp file from the enterprise edition CD rom or installation)

also, you can try this:
connect a shared folder on the AS server from the non-domain station, then
open the cube.
you can be authenticated using this procedure.

"Chris" <Chris (AT) discussions (DOT) microsoft.com> wrote in message
news:BC11FADE-149E-44A0-AF9A-B254BCA4BAAB (AT) microsoft (DOT) com...
Hi,
Users on my Domain are able to access OLAP cubes via excel, but those not
on
domain (users with laptops) are unable to. I see there is an Option in
excel,
while setting up the connection to OLAP Server, is to access the cube via
http and iis. Is this possible? If so, where can I find information in
getting iis to connect to the OLAP server?

I am using MSAS 2000.

Thanks




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.