Cannot login to Analysis Services 2008 from SQL Server Management Studio

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Cannot login to Analysis Services 2008 from...

11 posts, Page 1 of 2

1 2 »»

Cannot login to Analysis Services 2008 from SQL Server Management Studio

Rate Topic

Display Mode

Topic Options

Author

Message

sanjayadileepa-1150898

Posted Tuesday, July 27, 2010 9:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 03, 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

Meet George Jetson

Posted Tuesday, July 27, 2010 12:21 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 1,295, Visits: 1,220

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

sanjayadileepa-1150898

Posted Wednesday, July 28, 2010 3:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 03, 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

Giridhar A

Posted Wednesday, July 28, 2010 4:50 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, July 05, 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

Anekin

Posted Monday, November 01, 2010 12:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, February 06, 2011 11:15 PM
Points: 1, Visits: 29

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

ramu139

Posted Thursday, June 30, 2011 12:14 PM

Forum 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 Smile

Post #1134626

kazim.raza

Posted Monday, September 12, 2011 2:38 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 7:44 AM
Points: 450, Visits: 590

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

JoeMichel27

Posted Sunday, June 03, 2012 6:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 7:53 AM
Points: 2, Visits: 42

Machine name\instance name is not doing the trick for me.
It is frustrating!
Still looking for the solution.
Joe

Post #1310212

Bill Stutters

Posted Wednesday, June 20, 2012 2:08 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 11:28 AM
Points: 138, Visits: 319

Try restarting SQL Server Browser. That worked for me in SQL 2005.

Post #1318971

JoeMichel27

Posted Wednesday, June 20, 2012 5:01 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 7:53 AM
Points: 2, Visits: 42

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 »

11 posts, Page 1 of 2

1 2 »»

Permissions