Problem in displaying cubes using SSAS 2005

  • Article

Received this Error Message " Open connect failed. Error in the OLE DB Provider. Could not connect to the redirector. Ensure that the SQLBrowser Services is running on the server.”?

The SQL Browser is used when you are attempting to communicate with a named instance. What you are seeing is a known problem, fixed in SP1, where the SQL Browser needs communication with a domain controller to validate your access rights.

Here are few things you can check:

1) make it the default instance -- that works without any problems

2) always make sure a DC is available

3) make sure the XP firewall is disabled on the SQL Browser port# (and the various instance port#s)

4) attempt to connect specifically to the port # for the instance (which bypasses the redirector) -- try using <server>:<port#> syntax for the server name.

Other thing that you can do is that try to reinstall the "Workstation components" for the SQL Server.