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:
- Verify that the SQL Server Browser service is running. If not, start the service.
- 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.
- 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.
- Try to connect to SSAS by using the IP address of the server.