Life gives you learning lessons from unexpected times, here is one such experience that I felt is worth sharing. It may be a surprise to my blog readers that I also have SQL Server Analysis Services installed on my primary machine. I use it occasionally because most of the time I work with the SQL Server Database engine. One fine day, I opened SQL Server Management Studio and instead of a database engine, I selected analysis services (this was a mistake) and pressed on the connect button. Below is the error which I received for SQL Browser:
ADDITIONAL INFORMATION:
A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)
——————————
No connection could be made because the target machine actively refused it 127.0.0.1:2382 (System)
This is the first time I saw such error while connecting to SQL Server, but soon I realized that I was trying to connect to SQL Server Analysis Services. I could have left it there because I don’t use it, but I did not. Since there was a little time, I thought it is worth solving this challenge in front of me. Here is the step by step resolution of what I did:
- Made sure that SQL Server Analysis Service was up and running. This got confirmed from my SQL Server Configuration Manager.
- As I do always, read the error message again and verified that the SQL Browser service was up and running.
- Since this was a local connection, I turned off the firewall as well.
None of the above solved the problem. The Port resolution is done by the SQL browser service in case of SQL Server connectivity. So I thought that it could be a permission issue – just a guess based on the error message.
I noticed that SQL Browser was running with the local system account. I found on the internet that changing account helped many. So I used the SQL Server Configuration Manager to change the service account for the SQL Server Browser. I have used below.
Here are the steps:
- Open SQL Server Configuration Manager
- Right click “SQL Server Browser” and choose “Properties”
- In the “Log On” Tab select “Local System” under “Built-In” account.
Have you ever seen such error and found some other way to fix it? Please comment and let others also know. The best way to learn something is by sharing.
Reference: Pinal Dave (https://blog.sqlauthority.com)
52 Comments. Leave new
Thanks a lot, this helped .
Glad that it helped you siviwe.
Thank you so much! This helped me!
Manisha – I am glad it helped you.
No help, any other resolution?
Not aware.
Hi Pinal,
Im experiencing this on a SQL 2000 server (I still have to maintain it :().
Any advice on how to resolve it there?
Thanks in advance,
Teun
Teun – Sorry, don’t know how it works in SQL 2000.
Fixed it for me. Thank you very much, Pinal! :)
I am seeing this error when trying to set the aggregation options. Your fix did not work. Any other suggestions?
Never mind. I found that I had misspelled the server name.
Do you also recommend using Local System account for the production Environment?
Great!!
Your article helped me alot.
Thanks!!
Still got a problem. When I tried to changed it to Local System.
The service cannot be restarted, either because it is disabled or it has no enabled devices associated with it. [0x80070422]
Please help. Thanks!
I was googling for about 3 hrs… no solution at all….
Even from Microsoft web.
I need the SSAS up and running coz i’m gonna configure my B.I. Tool.
But then, i landed on your web site, and got the brilliant, easy, and accurate solution for my problem :)
Thanks thanks, thanks a lot for sharing with us
^_^
same problem with me..!!
I have made all the changes mentioned,but still im facing the issue.
Check event log to see any interesting errors.
Turned off windows fire fall,changed the services to local system
Thanks for sharing rayudu.
Thank so much
Your welcome Madhu.
I am on 2016 having same issues with SSAS
Error
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AppLocal.AdomdClient)
——————————
No connection could be made because the target machine actively refused it 127.0.0.1:2383 (System)
Can you check if Analysis service is installed and running?
I have SQL Server 2016 on a windows 10 machine for dev work. After trying several things, I resolved the issue by changing the account in SQL Server Configuration Manager / SQL Server Analysis Services to ‘This Account’ and specifying the user account I use for SQL Server.
Thanks a lot ! You’re my master!
I got this on a new SQL Agent job that failed to run and process cubes. I had entered an Engine instance in the Server field rather than a cube instance.
So it fixed?
Hi Pinal ,
I fixed similar issue when i replaced server name with IP address ..
ex : IPaddress\tabular (this was my instance)