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.




Array

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |