Not able to run Analysis Services

  • Hi All,

    Can anyone suggest me for the Following Error when i start the analysis Services in sql 2005

    1) when i try to start services using Surface area Configuration i got the Error

    A Connection Cannot be made to redirector.Ensure that 'SQL BROWSER' Service is running(I checked that SQL Browser was still running)

    Additional Information:

    No Connection could be made because the target machine actively refused it 127.0.0.1:2382

  • Hello,

    It could possibly be a Firewall issue, or may be it is trying to access the server on a port that is not listening or is not a SQL Server port. You can check the SQL Server ports in the SQL Server Configuration Manager, under the Protocols Node.

    Can you please describe your environment a bit more. Do you have a Firewall on the Server? Have you tried a reboot of the Windows Server? Does it work if you try to start it from Windows Service Manager?

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • If possible you can stop and start services "SQL Browser".

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • I found this posted elsewhere (thx PaulGR, Yorkshire, England), after much searching and frustration.

    My environent in XP SP2, SQL Server 2008m installed on my local box.

    I got the "target machine actively refuses..." when I tried to connect to AS on my local machine. This solved it:

    "After much trial and error I finally got this to work. Unfortunately, I'm not exactly sure why. I simply changed the SQL browser to run under the local system account. I think I'll have to watch Scott's videeos on service accounts again."

    DanO

  • Same with us. We're running SQL 2008 on Windows Server Enterprise and were getting the error "No connection could be made because the target machine actively refused it 127.0.0.1:2382 (System)" when trying to connect to SSAS locally. Adding rules to windows firewall didn't help. Only until switching the SQL Browser service account from "Local Service" to "Local System" did we get success connecting.

    I'm guessing this was due to the Browser service not listening on port 2382 when running as "Local Service". Doing a

    netstat -ao |find "2382"

    only returned results when the service is running as "Local System".

  • Hi Bruce Campbell,

    This worked for me too.

    Initially SQL Browser account running under local service. Changed service account for SQL browser to Local System.

    env:

    Analysis service: SSAS 2008 R2 Developer Edition

    OS: Windows 7 Professional x64

    Type: Named isntance

    Thanks,

    Brahma

  • Thanks Bruce,

    This really did the magic for me after days of trying to figure it out.

  • it worked once i changed browser service to run on LOCAL SYSTEM.

    Thank you all.:-)

    --DG.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply