dbTalk Databases Forums  

Accessing OLAP over the internet

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


Discuss Accessing OLAP over the internet in the microsoft.public.sqlserver.olap forum.



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

Default Accessing OLAP over the internet - 02-10-2006 , 10:16 AM






Hi
I wish to enable people to access MSOLAP cubes over the internet.
I have placed msolap.asp in the wwwroot folder on the alalysis server
('blade' - Windows 2000 Server) and we can now access cubes over the local
intranet fine using Pivot Tables Services with http://blade as the server.
However this is not our web server (sbs 2003). We host our own website
(www.strategic.eu.com) and if i try http://blade.strategic.eu.com then it
cannot find the server.

Do i have to do something within IIS on our web server to get all this
working?

Regards,
Richard

Reply With Quote
  #2  
Old   
sefe dery
 
Posts: n/a

Default Re: Accessing OLAP over the internet - 02-11-2006 , 02:11 PM






Richard Mabbitt schrieb:
Quote:
Hi
I wish to enable people to access MSOLAP cubes over the internet.
I have placed msolap.asp in the wwwroot folder on the alalysis server
('blade' - Windows 2000 Server) and we can now access cubes over the local
intranet fine using Pivot Tables Services with http://blade as the server.
However this is not our web server (sbs 2003). We host our own website
(www.strategic.eu.com) and if i try http://blade.strategic.eu.com then it
cannot find the server.

Do i have to do something within IIS on our web server to get all this
working?

Regards,
Richard
Hi Richard,

you have to create a folder in wwwroot on your -physical- webserver and
put in the msolap.asp. For testing, you have to use the anonymous
authentification in msolap.asp.

thats all.

Think about, you have to need the enterprise edition of as 2000!
http://support.microsoft.com/default...b;en-us;279489

Sefer


Reply With Quote
  #3  
Old   
Richard Mabbitt
 
Posts: n/a

Default Re: Accessing OLAP over the internet - 02-13-2006 , 04:58 AM



Thanks Sefe, but i'm still having no joy
I have created a folder called 'blade' - the same name as our OLAP server
and placed the msolap.asp file from blade into this folder. I've tried
changing the access of this folder to anonymous, windows, basic, nothing.
I can test the file is ok by going to
https://www.strategic.eu.com/blade/msolap.asp and i get the blank page as
expected.
But when i try https://blade.strategic.eu.com in pivot table services it
says the server name cannot be resolved.

"sefe dery" wrote:

Quote:
Richard Mabbitt schrieb:
Hi
I wish to enable people to access MSOLAP cubes over the internet.
I have placed msolap.asp in the wwwroot folder on the alalysis server
('blade' - Windows 2000 Server) and we can now access cubes over the local
intranet fine using Pivot Tables Services with http://blade as the server.
However this is not our web server (sbs 2003). We host our own website
(www.strategic.eu.com) and if i try http://blade.strategic.eu.com then it
cannot find the server.

Do i have to do something within IIS on our web server to get all this
working?

Regards,
Richard

Hi Richard,

you have to create a folder in wwwroot on your -physical- webserver and
put in the msolap.asp. For testing, you have to use the anonymous
authentification in msolap.asp.

thats all.

Think about, you have to need the enterprise edition of as 2000!
http://support.microsoft.com/default...b;en-us;279489

Sefer


Reply With Quote
  #4  
Old   
sefe dery
 
Posts: n/a

Default Re: Accessing OLAP over the internet - 02-16-2006 , 07:28 AM



Hi Richard,

it seems so that you have an iis setting failure. I am not very fit in
IIS, but you should proof this.

For test you schould create a virtual directory (testfolder/test.html)
in IIS-->WEBSITE-->"blade.strategic.eu.com"
and then try to open https://blade.strategic.eu.com/testfolder/test.html
if that work then the IIS settings are OK, otherwise i dont know!

Sefer

Richard Mabbitt schrieb:
Quote:
Thanks Sefe, but i'm still having no joy
I have created a folder called 'blade' - the same name as our OLAP server
and placed the msolap.asp file from blade into this folder. I've tried
changing the access of this folder to anonymous, windows, basic, nothing.
I can test the file is ok by going to
https://www.strategic.eu.com/blade/msolap.asp and i get the blank page as
expected.
But when i try https://blade.strategic.eu.com in pivot table services it
says the server name cannot be resolved.

"sefe dery" wrote:


Richard Mabbitt schrieb:

Hi
I wish to enable people to access MSOLAP cubes over the internet.
I have placed msolap.asp in the wwwroot folder on the alalysis server
('blade' - Windows 2000 Server) and we can now access cubes over the local
intranet fine using Pivot Tables Services with http://blade as the server.
However this is not our web server (sbs 2003). We host our own website
(www.strategic.eu.com) and if i try http://blade.strategic.eu.com then it
cannot find the server.

Do i have to do something within IIS on our web server to get all this
working?

Regards,
Richard

Hi Richard,

you have to create a folder in wwwroot on your -physical- webserver and
put in the msolap.asp. For testing, you have to use the anonymous
authentification in msolap.asp.

thats all.

Think about, you have to need the enterprise edition of as 2000!
http://support.microsoft.com/default...b;en-us;279489

Sefer


Reply With Quote
  #5  
Old   
Richard Mabbitt
 
Posts: n/a

Default Re: Accessing OLAP over the internet - 02-20-2006 , 05:03 AM



Hi
I found the answers here:
http://msdn.microsoft.com/library/de...l_datapump.asp

It turns out you have to modify the msolap.asp file to give it the name of
the Analysis Server name and also register copy and register msmdpump.dll
(the data pump engine) on the web server.

All is well now!

Regards,
Richard

Regards,
Richard

"sefe dery" wrote:

Quote:
Hi Richard,

it seems so that you have an iis setting failure. I am not very fit in
IIS, but you should proof this.

For test you schould create a virtual directory (testfolder/test.html)
in IIS-->WEBSITE-->"blade.strategic.eu.com"
and then try to open https://blade.strategic.eu.com/testfolder/test.html
if that work then the IIS settings are OK, otherwise i dont know!

Sefer

Richard Mabbitt schrieb:
Thanks Sefe, but i'm still having no joy
I have created a folder called 'blade' - the same name as our OLAP server
and placed the msolap.asp file from blade into this folder. I've tried
changing the access of this folder to anonymous, windows, basic, nothing.
I can test the file is ok by going to
https://www.strategic.eu.com/blade/msolap.asp and i get the blank page as
expected.
But when i try https://blade.strategic.eu.com in pivot table services it
says the server name cannot be resolved.

"sefe dery" wrote:


Richard Mabbitt schrieb:

Hi
I wish to enable people to access MSOLAP cubes over the internet.
I have placed msolap.asp in the wwwroot folder on the alalysis server
('blade' - Windows 2000 Server) and we can now access cubes over the local
intranet fine using Pivot Tables Services with http://blade as the server.
However this is not our web server (sbs 2003). We host our own website
(www.strategic.eu.com) and if i try http://blade.strategic.eu.com then it
cannot find the server.

Do i have to do something within IIS on our web server to get all this
working?

Regards,
Richard

Hi Richard,

you have to create a folder in wwwroot on your -physical- webserver and
put in the msolap.asp. For testing, you have to use the anonymous
authentification in msolap.asp.

thats all.

Think about, you have to need the enterprise edition of as 2000!
http://support.microsoft.com/default...b;en-us;279489

Sefer



Reply With Quote
  #6  
Old   
Richard Mabbitt
 
Posts: n/a

Default Re: Accessing OLAP over the internet - 02-20-2006 , 05:08 AM





"Richard Mabbitt" wrote:

Quote:
Hi
I found the answers here:
http://msdn.microsoft.com/library/de...l_datapump.asp

It turns out you have to modify the msolap.asp file to give it the name of
the Analysis Server name and also register copy and register msmdpump.dll
(the data pump engine) on the web server.

All is well now!

Regards,
Richard

Regards,
Richard

"sefe dery" wrote:

Hi Richard,

it seems so that you have an iis setting failure. I am not very fit in
IIS, but you should proof this.

For test you schould create a virtual directory (testfolder/test.html)
in IIS-->WEBSITE-->"blade.strategic.eu.com"
and then try to open https://blade.strategic.eu.com/testfolder/test.html
if that work then the IIS settings are OK, otherwise i dont know!

Sefer

Richard Mabbitt schrieb:
Thanks Sefe, but i'm still having no joy
I have created a folder called 'blade' - the same name as our OLAP server
and placed the msolap.asp file from blade into this folder. I've tried
changing the access of this folder to anonymous, windows, basic, nothing.
I can test the file is ok by going to
https://www.strategic.eu.com/blade/msolap.asp and i get the blank page as
expected.
But when i try https://blade.strategic.eu.com in pivot table services it
says the server name cannot be resolved.

"sefe dery" wrote:


Richard Mabbitt schrieb:

Hi
I wish to enable people to access MSOLAP cubes over the internet.
I have placed msolap.asp in the wwwroot folder on the alalysis server
('blade' - Windows 2000 Server) and we can now access cubes over the local
intranet fine using Pivot Tables Services with http://blade as the server.
However this is not our web server (sbs 2003). We host our own website
(www.strategic.eu.com) and if i try http://blade.strategic.eu.com then it
cannot find the server.

Do i have to do something within IIS on our web server to get all this
working?

Regards,
Richard

Hi Richard,

you have to create a folder in wwwroot on your -physical- webserver and
put in the msolap.asp. For testing, you have to use the anonymous
authentification in msolap.asp.

thats all.

Think about, you have to need the enterprise edition of as 2000!
http://support.microsoft.com/default...b;en-us;279489

Sefer



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.