question

SantiagoM-8422 avatar image
0 Votes"
SantiagoM-8422 asked AmeliaGu-msft edited

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

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.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SantiagoM-8422,
Did the answer help you?
Please feel free to let us know if you have any other question.
If you find the post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia

0 Votes 0 ·

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @SantiagoM-8422,
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?
93273-01.jpg


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.



01.jpg (92.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.