Re: AS 2005 HTTP access with Basic Authentication
- From: petery@xxxxxxxxxxxxxxxxxxxx (Peter Yang [MSFT])
- Date: Fri, 09 Dec 2005 02:46:47 GMT
Hi Scott,
The following is the connecting string works on my side for basic
authentication:
<script language="vbscript">
sub button1_onclick()
PivotTable1.ConnectionString = "Provider=MSOLAP;" + _
"Data Source=http://localhost/as2005/msmdpump.dll;Initial
Catalog=adventureworksdw;prompt=1"
PivotTable1.DataMember = "adventure works dw"
end sub
</script>
I wonder if you test this on different client machines. In addition, I
suggest that you use a html file to test directly other than a aspx file.
If the VD hosting the html file is different from the VD hosting
msmdump.dll, you may check security settings for both VDs.
Best 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.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>Thread-Topic: AS 2005 HTTP access with Basic Authentication
>thread-index: AcX8SvrZLk9yEPPgQmOEIhphOPvCyA==
>X-WBNR-Posting-Host: 66.115.208.110
>From: "=?Utf-8?B?U2NvdHQgSXZleQ==?=" <iveys@xxxxxxxxxxxxx>
>References: <3B651890-487C-4A78-B1DB-635E99C12C3F@xxxxxxxxxxxxx>
<eetHpJE$FHA.1988@xxxxxxxxxxxxxxxxxxxx>
<9C657D31-EA77-4B69-866B-841100DAE9F7@xxxxxxxxxxxxx>
<#k0D1mE$FHA.2520@xxxxxxxxxxxxxxxxxxxx>
>Subject: Re: AS 2005 HTTP access with Basic Authentication
>Date: Thu, 8 Dec 2005 14:59:01 -0800
>Lines: 102
>Message-ID: <87BEBCE0-C185-43AB-9114-615563011FA1@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!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:65302
>X-Tomcat-NG: microsoft.public.sqlserver.olap
>
>I'm using OWC 11 as the app, hosted inside sharepoint site. prompt=1 does
>nothing. I've tried changing every IE setting that I could think of to
see
>if that had anything to do with it, but no luck.
>
>
>Scott
>
>"Edward Melomed [MSFT]" wrote:
>
>> That is strange.
>>
>> What client application you are using?
>>
>> If you have MDXSample app , try in the connection dialog specify
provider as
>> "MSOLAP;prompt=1"
>> And you should see another box appear titled "Multidimensional
Connection
>> 9.0"
>>
>> Edward Melomed
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
rights.
>>
>>
>> "Scott Ivey" <iveys@xxxxxxxxxxxxx> wrote in message
>> news:9C657D31-EA77-4B69-866B-841100DAE9F7@xxxxxxxxxxxxxxxx
>> >I used prompt=1 in the connect string, but that doesn't work - I never
get
>> > prompted. Specifying user & password does work - but I'd like to have
it
>> > prompt for password instead. Are there any ideas why the prompt
doesn't
>> > work?
>> >
>> >
>> > Scott
>> >
>> > "Edward Melomed [MSFT]" wrote:
>> >
>> >> Once you enabled the Basic Authentication you need to make sure you
>> >> specify
>> >> your credentials.
>> >> You can do it ever by specifying "user" and "password" connection
string
>> >> properties in your connection string.
>> >> Or you can add "prompt=1" to your connection string and you will get
>> >> additional dialog asking for your credentials.
>> >>
>> >>
>> >> Edward Melomed
>> >> --
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >>
>> >> "Scott Ivey" <iveys@xxxxxxxxxxxxx> wrote in message
>> >> news:3B651890-487C-4A78-B1DB-635E99C12C3F@xxxxxxxxxxxxxxxx
>> >> > Hi all - hopefully someone here can help me out with this. I have
an
>> >> > open
>> >> > ticket on this with MS as well, and none of their techs seem to
know
>> >> > how
>> >> > to
>> >> > help me. I have enabled HTTP access to our Analysis Services 2005
>> >> > server
>> >> > by
>> >> > following the steps at
>> >> > http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx
-
>> >> > however, I need to use BASIC AUTHENTICATION instead of Windows
>> >> > Integrated.
>> >> > Once I enable basic and disable integrated, everything just stops
>> >> > working.
>> >> > I
>> >> > found another article saying that AS 2005 ignores basic
authentication
>> >> > by
>> >> > default, and gives steps to change the setting, but the screen that
>> >> > they
>> >> > talk
>> >> > about doesn't exist, and the one that does that looks similar
doesn't
>> >> > list
>> >> > the properties necessary to change. Link to that article is...
>> >> > http://msdn2.microsoft.com/en-us/library/ms174573.aspx. It says the
>> >> > following - "Based on the default setting of 1, Analysis Services
>> >> > rejects
>> >> > client requests that are submitted by using Basic authentication. To
>> >> > accept
>> >> > client requests that use Basic authentication, change the setting
for
>> >> > this
>> >> > property to 0." I tried to add the property directly thru
msmdsrv.ini
>> >> > file,
>> >> > but that didn't seem to work either. Anyone else have any other
ideas?
>> >> > I'm
>> >> > desperate here - I'm supposed to be on vacation tomorrow, and if I
>> >> > don't
>> >> > have
>> >> > this fixed by then, i'm in deep $*%!.
>> >> >
>> >> >
>> >> > Thanks!
>> >> >
>> >> > Scott Ivey
>> >>
>> >>
>> >>
>>
>>
>>
>
.
- References:
- Re: AS 2005 HTTP access with Basic Authentication
- From: Edward Melomed [MSFT]
- Re: AS 2005 HTTP access with Basic Authentication
- From: Edward Melomed [MSFT]
- Re: AS 2005 HTTP access with Basic Authentication
- From: Scott Ivey
- Re: AS 2005 HTTP access with Basic Authentication
- Prev by Date: Re: AS2005 XML/A access in standard edition?
- Next by Date: Re: MDX question
- Previous by thread: Re: AS 2005 HTTP access with Basic Authentication
- Next by thread: Re: AS 2005 HTTP access with Basic Authentication
- Index(es):
Relevant Pages
|
