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.

System Configuration Checker fails with “Performance Monitor Counter Check Failed” Message

Another issue I encounter during SQL Server 2005 setup is that System Configuration Checker fails with "Performance Monitor Counter Check Failed" message. By checking the detail of this message, I am prompted to examine the SQL Server 2005 Readme or BOL for the solution to this failure.

However, the solution in the Readme doesn’t work for me. The corresponding settings for the registry key described in the solution is correct on my computer. Additionally I found there is another 004 folder under Perflib which holds the same structure as that of 009. My OS is Windows XP MCE SP2 (Simplified Chinese). The SQL Server I am trying to install is SQL Server 2005 Dev (English).

Mmm…. Then I gave up the 009 folder and embraced 004, synchronised the Last Counter and Last Help of Perflib with the max value of Counter and Help in 004, respectively.

After I made the change, I restarted the installation of SQL Server 2005. The error message from System Configuration Checker is gone.

 

Conclusion: If the language of OS or SQL Server 2005 you are about to install is not English, you might try folders other 009 in case you encounter this error message from System Configuration Checker during the installation of SQL Server 2005.

You keep receiving the “Pending Reboot Requirement” error message during the System Configuration Check

I encounter an issue when I am trying to make change to the existing installation of SQL Server 2005. I continue to get the error Pending Reboot Requirement during system configuration check and I can’t move on to the next step.
 
The same thing keeps happening even if I have restarted the computer.
 
I finally resolved this problem by go to the following registry entry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
 
Then delete the PendingFileRenameOperations key.