Cannot connect to MSSAS 2005 Standard on local machine

I have installed SQL2005 completely, including Service Pack 1. Using Mgt Studio, I can connect to the relational db. I am not able to connect to analysis services though! The error message I receive is :"A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient". The additional information says: "Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.(System)."

The service is certainly running (I see this in the Mgt Studio).

I am able to connect to the service on another machine. However, once I try to browse a cube on another machine, I get the error message "Error HRESULT E_FAIL has been returned from a call to a COM component". I do not know whether these 2 problems are related or not.

Thanks a lot for your answer!

Joos

These two problems are probably unrelated.

Try and see if your "SQL Server Analysis Services(MSSQLSERVER)" service is running?

Try using "localhost" as a name when connecting to your local Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Analysis Services is running. I can see this under my registered servers and in services. I tried both localhost as machine name, without any luck. It is the standard edition on my XP laptop.|||What antivirus do you have? I have the same problem and it is because the antivirus is making some kind of blockage|||

I have panda running on my laptop. I also have a server (2003) with panda and SQL Enterprise installed. There it works fine...What do you suggest?

Thanks!

|||

Try uninstalling your untivirus software.

It has been reported (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=384104&SiteID=1) Panda will cause connection problems in some cases.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

No more thinking about it!!!!

You have panda

I have panda

You have the problem

I have the problem

MICROOOOOOOOOOSOOOOOOOOOOOOOOOFFFFFFFTTTTTT!!!!!!!!! AND PANDAAAAAAAAAAAAA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

REAAAAAAAAAAADDDDDDDDDDDDDDDD!!!!!!!!!!!!!!!!!!!!!!!!!!

DOOOOOOO SOMENTHINGGGGGGGGGGGGGGGGGGGGG!!!!!

|||

Jose is absolutely right!!! SQL2005 Standard edition on Windows XP with Panda Antivirus is a bad idea if you want to use Analysis Services!!!!

I removed Panda, restarted the pc and then it worked!

Thanks a lot Jose!

|||

You are very lucky because you can remove panda!!

I can't because i work for a big company and i can't remove panda antivirus

Please!!!!!!!!! Microsoft !!!!!!!! are you reading?

Please do something!!!

Panda!!!! this is not a good idea to block a Microsoft aplicattion!!! do something!!

fix it!!!

is it posible? the best supposed antivirus in the world blocking an aplication of Microsoft? Didn't you speak each other before making your products or wath?

to all people with the same problem (there are at least 10 questions posted whit this problem): try to uninstall your antivirus (specially if it's panda) and try again

|||

I'm running latest Panda Antivirus build "Titanium 2006 Antivirus + Antispyware " with no issue on my XPSP2 with AS 2005 SP1.

Which build do you use?

thx

Aus99

|||

I'm not sure. What i know is that it's a corporate version with true prevent.

Anybody with the same problem?

cannot connect to analysis server

I have installed sql 2k and analysis service 2k including sp3a on my PC with XP professional. When I try to connect to the olap service from the olap manager I get the "cannot open connection to the analysis server". Does any one has a clue on a solution?RTFM ... :D

You'll need to setup an ODBC - Connection to a msdb-file (foodmart sample) before you can use analysis manager for further proceedings ...

Do a quick browse through the "getting started" docs offered in the analysis manager result pane - (you'll not need 60minutes as is noted there to read them, just find the first step - "setting up an odbc dsn") -
from then on, you'll be able to connect to AS.

IMHO, a kind of really strange desgin , I just stumbled into this myself ...

cannot connect to analysis server

I have installed sql 2k and analysis service 2k including sp3a on my PC with XP professional. When I try to connect to the olap service from the olap manager I get the "cannot open connection to the analysis server". Does any one has a clue on a solution?RTFM ... :D

You'll need to setup an ODBC - Connection to a msdb-file (foodmart sample) before you can use analysis manager for further proceedings ...

Do a quick browse through the "getting started" docs offered in the analysis manager result pane - (you'll not need 60minutes as is noted there to read them, just find the first step - "setting up an odbc dsn") -
from then on, you'll be able to connect to AS.

IMHO, a kind of really strange desgin , I just stumbled into this myself ...