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.




Related Articles :

  • No Related Articles Found

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 |