Analysis Services connectivity issue from Remote Server
Problem:
I was recently working with one of my colleagues to setup a new server in Azure. He installed
all the SQL server components. When we tried to connect OLAP cubes from another
local or remote server, we were facing connectivity issue with the following error
message:
“A connection attempt failed
because the connected party did not properly respond after a period of time, or
established connection failed because connection host has failed to respond xxx.xxx.xxx.xxx:xxxx(System)."
Solution:
First we checked if SQL Server Browser
service was running (Log On As) under “Local Service”. We made the changes and
tried to connect SSAS through SQL Server Management Studio (SSMS) but no luck.
Then we guessed that may be our Windows Firewall was denying
the access. To solve this issue, we added a new inbound rule in Windows
Firewall for TCP port 2383. Please
note that SSAS port is 2383 (instead of SQL port 1433). After adding new port,
we were able to connect SSAS successfully from remote server.
I
hope this will help you in case you encounter similar problem.