none
The SQLBrowser service was unable to establish Analysis Services discovery.

    Question

  • Hi there.

     

    QL 2005 Enterprise X64

    Does anybody know anything about this warning. I've googled and try all available search engines, without any luck. Please advise

     

    Computer:  ServerName
    Source:       SQLBrowser
    Category:  None
    Type:         Warning
    Event ID:  9
    Description: The SQLBrowser service was unable to establish Analysis Services discovery.

     

    /torpo
    Monday, October 08, 2007 10:26 AM

All replies

  • Torpo,

    It´s a SQL Serve 2005 bug...

     

    You need to install SP1 and Hotfix pos SP1(http://support.microsoft.com/kb/918222).

    !!! Don't install SP2 on X64 (many bugs on SP2 X64).!!!

     

    There are others with the same problem:

    http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126457

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=599500&SiteID=1

     

    Regards

    Monday, October 08, 2007 1:52 PM
  • I had the same problem. I could only browse analysis services cubes when i had logged in on our network that day. Trying to browse cubes on days when I was out of office and never connected to the network (e.g. demo's at a customer) gave me the SQL browser error. This is caused by a securicy setting. In the group policies some certifcates were refreshed on logon. Appearently the SQL server browser service will not work if these certificates are not valid.

     

    I solved this issue by creating a local admin user to login to login when i am not connected to the network. This way the cerficates remain valid from the last logon on the network with my regular user .

     

    I am not sure if this issue is the same as the bug described in the previous answer to your post. Maybe this is intended behaviour for some reason.

    Tuesday, October 09, 2007 11:22 AM
  •  

    Hi Lucas.

     

    I'm not that happy with you answer. Not that it isn't usefull, but what it states. Because this is the version of my SQL Server:

    Microsoft SQL Server 2005 - 9.00.3175.00 (X64)   Jun 14 2007 11:45:39   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

     

    So i reckon that service pack 2 to the SQL is installed. Then what?

     

    Company policy dictates that all servers are running latest sp / hotfix.

     

    Thanks anyway

    Thursday, October 11, 2007 9:26 AM