July 27, 2010 at 9:23 am
Last week I installed SQL Server 2008 developer edition with service pack 1 on windows 7 Home Premium. Before install the SQL Server, I already installed .net framework 3.5 service pack 1. But when I login to the Analysis Services, following error is coming.
A connection cannot be made. Ensure that the server is running (Microsoft.AnalysisServices.AdomdClient)
No Connection could be made because the target machine actively refused it 127.0.0.1:2383
This is my personal laptop and I tried with local system and network service. SQL Server Browser is also running.
But I can login to Database Engine and Integration Services. But Analysis Services and Reporting Services are not working.
Please help me to solve this problem.
July 27, 2010 at 12:21 pm
I had a similar issue with SQL Server 2005, please try the suggestion below.
Check Programs|SQL Server 2005|Configuration tools|SQL Server Surface Area Configuration.
In "Surface Area Configuration for Services and Connection", you click on the service and remote connections.
See that you have local and remote connections activated.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
July 28, 2010 at 3:55 am
Thank you for the reply!
But there is no SQL Server Surface Area Configuration in SQL Server 2008. Then how could I check local and remote connections are activated in my computer.
July 28, 2010 at 4:50 am
Surface Area configuration is absent in sql server 2008 , instead these services are now available in the sql server configuration manager..
Properties -> Connections -> Check "Allow remote connections to this server".
November 1, 2010 at 12:54 am
Hi
I have the same problem
I can start/restart SSAS in configuration manager
but I am unable to connect locally/remotely using management studio..
I have other SSAS and on the same box and I have no problem connecting to those.
Can someone please help?
i also cant find
Properties -> Connections -> Check "Allow remote connections to this server".
in configuration manager
June 30, 2011 at 12:14 pm
I had a same issue.... while connecting to Analysis Services include Machinename(servername)\Instance name...this will solve your problem:-)
September 12, 2011 at 2:38 am
Machine name\instance name did the trick for me. I wonder if this is because I do not have it installed with the default instance name.
June 3, 2012 at 6:58 am
Machine name\instance name is not doing the trick for me.
It is frustrating!
Still looking for the solution.
Joe
June 20, 2012 at 2:08 pm
Try restarting SQL Server Browser. That worked for me in SQL 2005.
June 20, 2012 at 5:01 pm
Thanks so much Bill.
I had to go in as sa and work backwards from there.
Not pretty but it's also not the first or last time I will have to do that.
Joe
January 13, 2013 at 7:22 pm
I am getting the same problem too. I've updated the machine/server name to something different. But I am still getting the error while trying to deploy the project.
Any thought how to fix it?
Many thanks in advance for your help.
ps: I have restarted SQL service and SQL browser, yet still nothing has changed.
Regards
myDATAA
September 5, 2013 at 5:12 pm
I had the same issue. I forgot that I installed the Analysis Service (AS) after the DB engine was installed, so the AS ended to be another instance.
I was able to log in with the ServerName\SSAS as instance.
Thanks for your help!:-)
August 11, 2014 at 7:00 am
Hi running Sql server 2008 R2 on Windows 7 Developer on one PC running as administrator. I can create a cube and deploy it, however when I try click on the Calculate tab it says cannot connect and the Metadata tab also reports no connection. Also I cannot connect from SSMS to SSAS however when I select (Connect) Options I can see the SSAS database. Error is:
The connection timed out. (Microsoft.AnalysisServices.AdomdClient). All the Services involved are running as LOCALSYSTEM apart from Browser as NT AUTHORITY\LOCALSERVICE.
I can connect ro SSIS and SSRS from SSMS.
Please Advise..
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply