I cannot connect to Analysis Services on a local box running XP with SP2 -
it fails with the following error:

TITLE: Connect to Server
------------------------------
Cannot connect to mycomputername.
------------------------------
ADDITIONAL INFORMATION:
A connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)
------------------------------
Unable to write data to 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
------------------------------

And when I try to change the setup using the Surface Area Configuration tool
it won't let me do it with the following error:
TITLE: Surface Area Configuration
------------------------------
To configure Analysis Service remote connections, you must be an
administrator for the Analysis Services Windows service. (SQLSAC)

To the best of my knowledge the service is running under my user name and I
am part of the local Admin group. Any suggestions? Thanks.

Jiri

P.S. Everything works fine on another box (Win 2003 Server) using a Standard
Edition but I would like to have it working on this one for development.

do you have any firewall between the computers?
are you in the same domain?

"Jiri" <Jiri (AT) discussions (DOT) microsoft.com> wrote

It is all running on/against the same box (and the same is happening on
multiple computers) - I simply cannot connect to the local AS. I did a
complete "clean" install (OS, patches, frameworks 1.0, 1.1 and 2.0, Office
and SQL Server) on one test box and it works on that one. The problem is that
some of the other boxes are development machines with lots of other software
installed a complete reinstall of everything is not really an option. Thanks.

Jiri

"Jeje" wrote:

does the problem appends with only 1 server?
or does your station cannot access all AS2005 servers?

when you try to change the AS config, do you do this on the server himself
(using terminal server or directly on the server)?
on the server himself, do you have any other issue?

"Jiri" <Jiri (AT) discussions (DOT) microsoft.com> wrote

I can access AS2005 on other computers but not on these "development" ones. I
sort of suspect the .Net framework (installed as 1.0, later 2.0 and 1.1 as
the last one) but unistalling it from one of these computers "hosed" it and I
had to start from scratch. Thanks.

"Jeje" wrote:

mmm...
something strange here. I have setup different computer with different
configs and software installed, and all stations works fine against our
cube server(s)

do you see any error in the windows event log?

"Jiri" <Jiri (AT) discussions (DOT) microsoft.com> wrote

Problem solved - it was Panda Software AV. No idea why - it should only scan
files (we do not use the firewall feature), all database-related files are
excluded but somehow it stops AS2005 from working. But only on a XP box - I
have it running side-by-side on a W2K3 Server without a problem.

Jiri

P.S. Nothing but trouble with Panda Software - this is by far not the first
problem. The biggest one is that the software does something (like causing
this problem or even deleting files and registry entries) without any trace.
We had to unistall it from our Exchange boxes since it was crashing them
repeatedly, it was messing up with file replication (we had to pay MSFT
support to get it identified) and they never seem to be able to help or fix
anything. Very frustrating ...

"Jeje" wrote: