April 16, 2003 at 11:24 pm
Hello,
We are using http method (msolap.asp) to access our OLAP server on the internet. But it seems I couldn't control security under this scenario. The user id and password seemed ineffective. Does anybody have such experience? Any solutions?
Thanks!
April 21, 2003 at 12:00 pm
This was removed by the editor as SPAM
April 23, 2003 at 6:30 am
Hi zchen,
Are you using IIS security (e.g. basic authentication)? If yes, then the user connecting needs to exist in the domain of the IIS server, or be from a trusted domain.
HTH,
Steve.
Steve.
April 23, 2003 at 8:07 am
What is this method of connecting to OLAP? I though only way you can have it on internet is either through 3rd Party tool or through Pivot Table controls.
Thanks.
April 23, 2003 at 6:15 pm
Do you mean OWC (Office Web Controls)? Everything goes through PTS eventually, even 3rd party products.
You can (theoretically, not tried it myself) connect using Excel. Just follow standard procedure for creating the 'new database query' but put an http address and UID/PWD rather than a local server name in the connection details textbox. The security for IIS plus the msolap.asp page have to be in place, but re-reading the BOL, this appears to be a valid setup and should work. This is good for a smaller implementation, but would not necc be a first choice for a production delivery solution.
You should also be able to use Analysis Manager to connect to a server via the internet too. Once again, not tried it but the setup is covered off in BOL.
Steve.
Steve.
April 30, 2003 at 10:31 pm
I finally got it figured out.
I didn't set the basic authentication on msolap.asp. After I did that, it works just fine.
Thank you anyway!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply