Has anyone seen this issue with sqlbrowser "failed starting OLAP redirection services with error 1."?

Question

Hello - I'm seeing an unusual sqlbrowser issue where it's not responding even though it's up and running. When running manually I see this.

I’m seeing this Warning: when manually running it also doesn’t respond to queries so I’m pretty sure that’s what causing the issue:

D:\>"c:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe" -c
SQLBrowser: starting up in console mode
SQLBrowser: starting up SSRP redirection service
SQLBrowser is successfully listening on ::[1434]
SQLBrowser is successfully listening on 0.0.0.0[1434]
[8220]: Waiting for next request...
[2392]: Waiting for next request...
[2100]: Waiting for next request...
[8060]: Waiting for next request...
[8220]: Received request...
[2392]: Received request...
[2100]: Received request...
[8060]: Received request...
SQLBrowser: starting up OLAP redirection service
[8220]: Waiting for next request...
[2392]: Waiting for next request...
[2100]: Waiting for next request...
[8060]: Waiting for next request...
SQLBrowser: Warning: failed starting OLAP redirection services with error 1.

Answer 1

Hi @Santiago M ,
Welcome to Microsoft Q&A.
Could you try to please go to registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\SQL Browser\AnalysisServiceListener and set it to 0?

This workaround works for me. Please refer to this thread which might help.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.