SEO

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.

Well, do I feel dumb - all I had to do was deploy the cube and the browser
worked.

Sorry to have bothered the group.

Tom Dacon
Dacon Software Consulting

"Tom Dacon" <tdacon@community.nospam> wrote in message
news:eYLMM$xoIHA.3900@TK2MSFTNGP05.phx.gbl...
> 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.
>
>