Connectivity Issue: "A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running"

  • Article

Symptoms:

SSAS Named Instance running on cluster with two nodes, on one instance we are able to connect SSAS using Name Instance but when you failover to other node and try to connect we get error message

SSAS Cluster Virtual Server Name – SSASVirtualServer

Instance is MySSAS

Two Nodes: NodeA, NodeB

When NodeA is owner of SSASVirtualServer and we connect SSASVirtualServer\MySSAS it works but when we failover SSASVirtualServer to NodeB and try to connect SSASVirtualServer\MySSAS it fails with error: A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running.

 

Cause:

The startup of SQL Browser account does not have permission to access msmdredir.ini. The startup account of SQL Browser should have both Read and Write permission to the ASconfig folder or its child objects.
By default, the SQL Browser will periodically check and update the 90\Shared\ASConfig\msmdredir.ini file to ensure it knows the named instance SSAS info(port..etc) and it will translate client who needs to connect to the named instance SSAS to the correct name and port.

Solution:

Red more…………………….