Error message when you connect to an instance of SSAS: “A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running”

When you try to connect to an instance of SQL Server 2005 Analysis Services from SQL Server Management Studio, you receive the following error message:
 
A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices)
 
Additional information:
    No connection could be made because the target machine actively refused it (System)
 
I checked the SQL Server Browser service and it is running happily at the moment.
 
I guess the problem may occur after you have additionally installed SQL Server Express after you have installed SQL Server 2005.
 
I finally resolved this by deleting all the files in the following folder: %ProgramFiles%\Microsoft SQL Server\90\Shared\ASConfig.  And then connect from Management Studio again.

One thought on “Error message when you connect to an instance of SSAS: “A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running”

  1. what are u talking abouttttt
    after i come to this page i suddenly find that i have been zero in computer and in computer application

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s