Re: HTTP Access to AS 2005 not working
- From: petery@xxxxxxxxxxxxxxxxxxxx (Peter Yang [MSFT])
- Date: Wed, 23 Nov 2005 09:02:20 GMT
Hello Pat,
I agree with Darren that this Activex control such as pivottable on client
side need to authenticate to server by itself when connecting.
Based on my test, this issue does not occur when using Windows integration
authenction.
When using basic authentication without prompt=1, I received the exact
error message you encountered.
When setting prompt=1, I could access from both server console and client
but prompted to input credential to access of server (basic authentication
behavior) and configure AS server/connection in dialog.
I believe this is normal behavior when using basic authentication on olap
VD as Darren mentioned.
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: HTTP Access to AS 2005 not working
| thread-index: AcXvqzj6g7+8TXDoTVSMCCa+UGH+CA==
| X-WBNR-Posting-Host: 145.254.241.103
| From: =?Utf-8?B?UGF0?= <pat@xxxxxxxxxxxxx>
| References: <FD259FC7-BDF8-4341-BD8D-9E3F104EF036@xxxxxxxxxxxxx>
<MPG.1debcbcd41447e029897db@xxxxxxxxxxxxxxxxxx>
<BC2C085E-E44B-4E88-9C04-91C239679214@xxxxxxxxxxxxx>
<52DA05D1-181B-49EC-A724-924F4A465694@xxxxxxxxxxxxx>
<#Bxoov57FHA.1484@xxxxxxxxxxxxxxxxxxxx>
| Subject: Re: HTTP Access to AS 2005 not working
| Date: Tue, 22 Nov 2005 13:25:12 -0800
| Lines: 40
| Message-ID: <E81223C9-A241-4B5C-8EB0-8397A3858C3C@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:64748
| X-Tomcat-NG: microsoft.public.sqlserver.olap
|
| The problem occurs on the server. I shouldn't have to have "prompt=1" in
the
| OWC connection string, since I've authenticated myself to IIS.
|
| The prompt=1 causes OWC to ask for authentication again. This shoudn't be
| necessary, and will prevent any client from connecting to the AS. And
yes,
| the clients have OLEDB 9 installed.
|
|
| "Edward Melomed [MSFT]" wrote:
|
| > Download and install
| >
http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8
F9FAD/SQLServer2005_ASOLEDB9.msi
| >
| > on your client.
| >
| > Edward Melomed.
| > ----
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > "Pat" <pat@xxxxxxxxxxxxx> wrote in message
| > news:52DA05D1-181B-49EC-A724-924F4A465694@xxxxxxxxxxxxxxxx
| > > It has to do with Authentication.
| > >
| > > When I add "prompt=1" to the OWC connection string, I'm asked for
UserID +
| > > password again, and I can subsequently work with the cube. That works
when
| > > I
| > > call the OWC page from within the server.
| > >
| > > When I try calling the same page from a remote client, I'm also asked
for
| > > userid + password again (once for basic auth before the page loads,
and
| > > once
| > > because of the OWC connection string) and I then get: "Either a
connection
| > > cannot be made to the MyServer server, or Analysis Services is not
running
| > > on
| > > the computer specified".
| > >
| >
| >
| >
|
.
- References:
- Re: HTTP Access to AS 2005 not working
- From: Darren Gosbell
- Re: HTTP Access to AS 2005 not working
- From: Edward Melomed [MSFT]
- Re: HTTP Access to AS 2005 not working
- Prev by Date: Re: Linked Server to Analysis Services 2005
- Next by Date: Re: Olap Services closes with "out of memory" error once in few days.
- Previous by thread: Re: HTTP Access to AS 2005 not working
- Next by thread: Re: HTTP Access to AS 2005 not working
- Index(es):
Relevant Pages
|
