Re: MDX Sample App broken by 2005



I talk about this a bit in the AS Operations Guide in the security
section -- I give several workarounds (albeit with various security issues
associated with the). You might find it useful as an alternative to http
access if this is all you are using http access for (i.e. to cross untrusted
domains)
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"James" <aa1948@xxxxxxxxxxxxx> wrote in message
news:E5282060-8882-4FF4-9659-E58E1FD7BC55@xxxxxxxxxxxxxxxx
> Hi Peter, Windows authentication wouldn't work since client and server are
> in
> different non-trusted domains. If Windows auth would work, I wouldn't need
> HTTP.
>
> I did follow the article you mention and also installed OLEDB 9 on the
> client.
> Can you get it to work in a scenario where client and server are in
> separate
> non-trusted domains? The user signed-in at the client must not exist with
> the
> same password on the server.
>
> I'm open to suggestions as of how I can access my AS server from outside
> the
> domain.
>
>
>
> "Peter Yang [MSFT]" wrote:
>
>> Hello,
>>
>> To understand the issue better, I'd like to know how you configure
>> authentication method for the 2005 olap VD, do you use Windows
>> authentication or basic authentication?
>>
>> You may want to refer to the following article:
>>
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx
>>
>> Regards,
>>
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>>
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>>
>> =====================================================
>>
>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> --------------------
>> | Thread-Topic: MDX Sample App broken by 2005
>> | thread-index: AcXw6UpsN93v0MLXRzyzy1AsszoI2Q==
>> | X-WBNR-Posting-Host: 84.147.161.107
>> | From: "=?Utf-8?B?SmFtZXM=?=" <aa1948@xxxxxxxxxxxxx>
>> | Subject: MDX Sample App broken by 2005
>> | Date: Thu, 24 Nov 2005 03:22:01 -0800
>> | Lines: 20
>> | Message-ID: <096FD515-5DA8-45C7-97A4-CC632553028D@xxxxxxxxxxxxx>
>> | MIME-Version: 1.0
>> | Content-Type: text/plain;
>> | charset="Utf-8"
>> | Content-Transfer-Encoding: 7bit
>> | X-Newsreader: Microsoft CDO for Windows 2000
>> | Content-Class: urn:content-classes:message
>> | Importance: normal
>> | Priority: normal
>> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> | Newsgroups: microsoft.public.sqlserver.olap
>> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:64833
>> | X-Tomcat-NG: microsoft.public.sqlserver.olap
>> |
>> | I'm using the MDX Sample Application to access our AS2000 SP3 cubes via
>> HTTP,
>> | with success.
>> |
>> | I've tried the same with AS2005, and I get all sorts of errors,
>> although
>> I
>> | allways try to connect in the same manner.
>> | For instance "Unable to establish connection. Object or provider is not
>> | capable of performing operation", or
>> | "XML parsing failed at line 1, column 0: A document must contain
>> exactly
>> one
>> | root element"
>> |
>> | The connection string for the failing AS2005 access:
>> | "http://SERVER/olap/msmdpump.dll;prompt=1";, and the provider MSOLAP.3
>> |
>> | For AS2000 access (and this is working fine): "http://SERVER/VirtDir/";,
>> and
>> | the provider MSOLAP.2
>> |
>> | The client and the server are in 2 separate, non-trusted domains
>> (otherwise
>> | I wouldn't need to use HTTP)
>> |
>> |
>> |
>>
>>


.



Relevant Pages

  • Re: breaking the model
    ... > The forms data then is in the Request object. ... HTTP Request; in this case, the form POST Request from the Page. ... client and server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Banana Republic (was Re: OpenVMS Book Wins award)
    ... client ... No bollocks HTTP, SOAP, XML, Java, Garbage ... receive messages from any number of server processes who in turn could be ... Unlike TCP/IP and/or UDP Sockets with Java that have been around since ...
    (comp.os.vms)
  • Re: MSAS Licensing Part II
    ... wish to use http access then you must have Enterprise Edition. ... PTS looks at the server name. ... You will note that all of this is totally transparent to the client. ...
    (microsoft.public.sqlserver.olap)
  • Re: Ajax in sync mode works with IE, does not work with Firefox
    ... HTTP is sessionless. ... does its close or half-close, the HTTP server will get a FIN (modulo ... then the server would be notified of socket disconnection ... If it's a stream socket, over TCP, then if the client closes its end, ...
    (comp.lang.javascript)
  • Re: Firewall session disconnects after 2 minutes of inactivity
    ... I want to start by pointing out the following: HTTP keep-alives and anything ... involved in the early stage of the connection when the client downloads the ... The HOD server I mean. ... when the session takes place through the ISA Server? ...
    (microsoft.public.isa)