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 12»»

Cannot login to Analysis Services 2008 from SQL Server Management Studio Expand / Collapse
Author
Message
Posted Tuesday, July 27, 2010 9:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 3, 2011 6:48 PM
Points: 4, Visits: 20
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.

Post #959488
Posted Tuesday, July 27, 2010 12:21 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:11 PM
Points: 1,771, Visits: 1,324
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.
Post #959609
Posted Wednesday, July 28, 2010 3:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 3, 2011 6:48 PM
Points: 4, Visits: 20
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.
Post #959918
Posted Wednesday, July 28, 2010 4:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 5, 2012 7:05 AM
Points: 68, Visits: 106
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".
Post #959938
Posted Monday, November 1, 2010 12:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 22, 2014 1:58 AM
Points: 1, Visits: 47
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
Post #1013691
Posted Thursday, June 30, 2011 12:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 19, 2011 9:48 AM
Points: 4, Visits: 27
I had a same issue.... while connecting to Analysis Services include Machinename(servername)\Instance name...this will solve your problem
Post #1134626
Posted Monday, September 12, 2011 2:38 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, August 1, 2014 12:12 AM
Points: 456, Visits: 597
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.
Post #1173226
Posted Sunday, June 3, 2012 6:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 11:09 AM
Points: 2, Visits: 58

Machine name\instance name is not doing the trick for me.
It is frustrating!
Still looking for the solution.
Joe
Post #1310212
Posted Wednesday, June 20, 2012 2:08 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:12 PM
Points: 138, Visits: 346
Try restarting SQL Server Browser. That worked for me in SQL 2005.
Post #1318971
Posted Wednesday, June 20, 2012 5:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 11:09 AM
Points: 2, Visits: 58
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
Post #1319025
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse