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

Answer this question

Cannot connect to MSSAS 2005 Standard on local machine

R.S
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!
alan lan
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!!!!!
voko
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.
ScorpDaddy
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
Shotmaker

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.
awani
I'm not sure. What i know is that it's a corporate version with true prevent.

Anybody with the same problem
rjherbein
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
Allison
What antivirus do you have I have the same problem and it is because the antivirus is making some kind of blockage
LabibaSeif

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
Aaron Winters
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!
Cannot connect to MSSAS 2005 Standard on local machine

Answer this question