Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sqlraider
Yak Posting Veteran
65 Posts |
 Posted - 2011-03-04 : 12:38:43
|
| Using SQL Server 2008 R2.Cannot connect to Analysis Services from SSMS on my PC(I can using BIDS from my PC). I am also getting the same error when attempting to connect to the Analysis Services server from Excel 2010 using the Data Connection Wizard(from my PC).I get the following (time out) error:"the following system error occurred: a connection attempt failed because the connected party did not respond after a period of time, or established connection failed because host has faild to respond."If I remote desktop into the server with the same ID I am able to connect from SSMS & BIDS.Is there a setting I have overlooked?Thanks. |
|
|
Sqlraider
Yak Posting Veteran
65 Posts |
Posted - 2011-03-07 : 14:32:31
|
| Found the solution.It was a port/firewall issue.After more google research I was able to find the port causing the issue. The port was blocked by the firewall to remote connections. Once the port was unblocked I was able to connect via SSMS & Excel. |
 |
|
|
|
|
|
Unable to connect to Analysis Services