Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Not able to run Analysis Services Expand / Collapse
Author
Message
Posted Sunday, January 18, 2009 11:07 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, February 10, 2010 2:51 AM
Points: 1,034, Visits: 11
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
Post #639091
Posted Monday, January 19, 2009 1:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 6:56 AM
Points: 1,330, Visits: 1,434
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
Post #639124
Posted Monday, January 19, 2009 4:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #639184
Posted Saturday, December 19, 2009 8:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 27, 2012 9:39 AM
Points: 1, Visits: 4
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
Post #836799
Posted Monday, November 15, 2010 12:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 15, 2010 12:43 PM
Points: 20, Visits: 10
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".
Post #1021010
Posted Wednesday, January 18, 2012 2:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:07 PM
Points: 5, Visits: 517
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
Post #1238285
Posted Wednesday, August 21, 2013 12:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 6:25 AM
Points: 1, Visits: 4
Thanks Bruce,

This really did the magic for me after days of trying to figure it out.
Post #1486841
Posted Tuesday, September 10, 2013 7:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 21, 2013 1:06 PM
Points: 1, Visits: 107
it worked once i changed browser service to run on LOCAL SYSTEM.

Thank you all.

--DG.
Post #1493417
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse