While deploying a System Center 2012 R2 Service Manager data warehouse server I noticed that I could no longer connection to the clustered 2012 SP1 SQL Analysis Services. Twenty four hours of troubleshooting later, it was because the SQL browser service on each cluster node was returning an IPv6 TCP port for the Analysis Service Instance. I am not actively using IPv6 in this scenario. The configuration file is stored here:
\Program Files (x86)\Microsoft SQL Server\90\Shared\ASConfig\msmdredir.ini
I stopped the SQL Server Analysis Service from the Failover Cluster Manager, and removed this line from the ini file:
<PortIPv6>xxxxx</PortIPv6>.
I repeated this step on the other cluster nodes, and then started the service from the FCM I could then connect with SSMS, and the SCSM DW installation wizard continued.
