Connectivity Issue: "A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running"
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:
Comments
- Anonymous
April 16, 2014
Another source of this issue might be a server rename (e.g. cloning a VM) or a server that moves domains. In that case go to C:Program Files (x86)Microsoft SQL Server90SharedASConfig, right-click for properties, go to security and make sure the user SQLServer2005SQLBrowserUser$(servername) has Modify rights.