SQLBrowser service was unable to establish Analysis Services

September 6, 2008

I had been having the abovementioned problem (couldn’t even connect to my AS server using Management Studio on my local machine). I installed SP1 and all post SP1 hotfixes. Even this didn’t seem to help the problem. What DID help it was to check the accounts under which the relevant services were running:

1) Ensure the “SQL Server Browser” service is running under the Local System account (I previously was using a NETWORK SERVICE account – which was probably my own fiddling fault.).

2) My “Sql Server Analysis Services (InstanceName)” Service is also running as Local System.

And then it worked. Hooray!.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: