Re: Problem with anonymous connections

Tech-Archive recommends: Fix windows errors by optimizing your registry

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 -


.

Quantcast