Re: Browser error - analysis services tutorial

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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@xxxxxxxxxxxxxxxx> wrote in message
news:eExfJpBoIHA.4848@xxxxxxxxxxxxxxxxxxxxxxx
Hello, folks -

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.















.

Relevant Pages

  • Re: Unable to connect to SQLExpress Remotely - no matter what
    ... Hard to speculate since the last time I suggested browser was a potential ... sqlbrowser show up as listening on UDP port 1434? ... It has something to do with the SQL Server ... Browser service not operating correctly. ...
    (microsoft.public.sqlserver.connect)
  • Re: Access 2007 ADP project will not connect to SQL Server 2008
    ... I got this connection to work by turning on the SQL Server Browser. ... ADPs way off connecting verses Management Studio or a simple DSN. ...
    (microsoft.public.access.adp.sqlserver)
  • right padding equivalent
    ... my confession is I dont use SQL server so can't help them ... It appears this is padding correctly but the spaces are not ... rendering in the browser. ...
    (comp.databases.ms-sqlserver)
  • Re: Unable to connect to SQLExpress Remotely - no matter what
    ... browser service that I began to suspect the browser service once again. ... (i.e. no ip or port numbers allowed for whatever reason). ... It has something to do with the SQL Server ... that would indicate that the connection is not getting to SQL Server. ...
    (microsoft.public.sqlserver.connect)
  • Re: C# equivelent of VBA "with..end with" statement
    ... Services in SQL Server 2008 (this from the Microsoft SQL Server web site) ... Tom Dacon ... Dacon Software Consulting ...
    (microsoft.public.dotnet.languages.csharp)