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
Event ID: 9
Description: The SQLBrowser service was unable to establish Analysis Services discovery.
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:
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.
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.