Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Not able to run Analysis Services


Not able to run Analysis Services

Author
Message
venkatg86
venkatg86
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1034 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
John H Marsh
John H Marsh
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1341 Visits: 1455
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
free_mascot
free_mascot
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2879 Visits: 2235
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."
doconnell 55468
doconnell 55468
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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
Bruce Campbell
Bruce Campbell
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
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".
w2bsqldba
w2bsqldba
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 595
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
briandexdick
briandexdick
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 6
Thanks Bruce,

This really did the magic for me after days of trying to figure it out.
205.dileep
205.dileep
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 127
it worked once i changed browser service to run on LOCAL SYSTEM.

Thank you all.:-)

--DG.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search