![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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 |
#5
| |||
| |||
|
|
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 |
#6
| |||
| |||
|
|
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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |