A Connection Cannot be Made to Redirector

When trying to connect to a SQL Server Analysis Service (SSAS) cube from SQL Server Management Studio (SSMS) you may experience the following error:

Cannot connect to <server_name><instance_name>.
A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)

Solution:

  1. Verify that the SQL Server Browser service is running. If not, start the service.
  2. Verify that the server where the cube is running is accessible from a remote/different machine. If the server cannot be connected to it may be a problem related to a virus scanner, firewall or user permissions.
  3. Verify that an IP address is obtained by using the IPCONFIG command from the command prompt. You can use IPCONFIG /RELEASE and IPCONFIG /RENEW from the command prompt to obtain an IP address.
  4. Try to connect to SSAS by using the IP address of the server.

]]>

Leave a Reply

Your email address will not be published. Required fields are marked *