Hi, folks - I tried this question in the OLAP group without any responses,
so I'm casting my net a little wider in hopes one of you may be able to help
me:


I'm an Analysis Services noob, running the SQL Server 2005 Analysis Services
tutorial for the first time.

In the Visual Studio 2005 IDE, after following the tutorial to design a
cube, I click on the Browser tab, and get this error:

No connection could be made because the target machine actively refused
it 127.0.0.1:2383

A Google search didn't lead me to anything helpful, although there were
plenty of reports of this error message in many other contexts besides this
one, and I followed every lead I saw with no success.

Both the SQL Server Analysis Server and SQL Server Browser services are
running. The analysis server service runs as Local System, and the browser
service runs by default as Network Services, but I get the same error if I
set it up to run as Local System.

Sql Server 2005 is fully updated, to service pack 2 and the latest security
updates. Visual Studio 2005 is fully updated, up to service pack 1 and the
latest security updates. I'm running fully-patched Windows XP. All three of
these were updated right up to the minute via Windows Update this morning.

Everything is installed on my local machine. I'm the local administrator on
the box, and SQL Server 2005 is the Developer Edition, with a full install
of everything on the DVD, with all defaults except that I installed a named
instance.

I run the Norton 360 firewall, but I get the error even when the firewall is
disabled.

Any suggestions?


Thanks,
Tom Dacon
Dacon Software Consulting


And here's a puzzler: After testing the SQL Server Browser running as Local
System, I wanted to switch it back to running as Network Services, but how
in the heck do I find out what the password is? First time I've ever tried
this, and I'm stumped.

Thanks for any help you can give me.