USEFUL SITES :
Write for Us
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.