Re: Problem with anonymous connections

oohhh...
only old technology...

can you switch to ASP.NET + ADOMD.NET?
instead of ASP + ADO.

it will be easier to implement and to debug.

but you can use another user account instead-of IUSR_machine
ideally, use a domain account.


"Richard Hollis" <richnews@xxxxxxxxxxxxxxxxx> wrote in message news:1191854542.747750.155130@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi

I'm using the ADO recordset object to get data and this is in an ASP
script running under IIS6. So I'm trying to get an ASP script to talk
via ADO to SSAS and get a recordset back.

So do I need to manually change the password of the local IUSR_machine
account - just so that I know what it is - and then create the same
account name on the SSAS machine? Should that work?

Richard

On Oct 6, 1:04 am, "Jeje" <willg...@xxxxxxxxxxx> wrote:
how the user access the application?
1. through a web application?
2. using a client/server tool? (like excel)

if 1:
insure that your application use a specific impersonation account instead of
delegating the active user.
and make sure that account / password used exists on the SSAS server too

if 2:
the user can open a shared folder on the SSAS server first (so the user is
prompted for a login/password and then he can access the cube
or
you can use the HTTP/XMLA access and the user can type a spefici login /
password to access the server

and finally for the anonymous access, I think you have to activate the guest
account in windows.

"Richard Hollis" <richn...@xxxxxxxxxxxxxxxxx> wrote in message

news:1191597452.315361.200900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



> Hi

> I cannot seem to make anonymous connections work with AS2005. I've
> enabled anonymous connections in the surface area config and restarted
> the default (MSSQLSERVER) AS instance, but cannot connect. I can see
> a single Login audit event in the Profiler for ANONYMOUS LOGON when
> attempting to connect from a remote server and then on the client the
> following error pops up. I've added the anon logon to the role, but I
> don't think its even getting to the authorizing stage. Any ideas? I
> cannot use integrated authentication because the two boxes are in
> different domains/workgroups.

> Thanks
> Richard

> Error detail:

> TITLE: Connect to Server
> ------------------------------

> Cannot connect to SERVERNAME.

> ------------------------------
> ADDITIONAL INFORMATION:

> A connection cannot be made. Ensure that the server is running.
> (Microsoft.AnalysisServices.AdomdClient)

> ------------------------------

> Unable to read data from the transport connection: An existing
> connection was forcibly closed by the remote host. (System)

> ------------------------------

> An existing connection was forcibly closed by the remote host (System)

> ------------------------------
> BUTTONS:

> OK
> ------------------------------- Hide quoted text -

- Show quoted text -


.