Hi, we have a problem with MSSQLServerOLAPServices
service, it cannot be started from the SQL Server Service
Manager and not even from the Control Panel->Services. We
have NT 4.0 as the OS and also SQL Server 2000. Once we
tried to start the service it tries to start but it
remains in that state and never starts. We follow the
microsoft KB article
http://support.microsoft.com/default.aspx?scid=kb;en-
us;264559&Product=nts40#appliesto steps but it didn´t
work. Somebody knows what could be the problem?
Thanks in advance.

"Omar Lopez" <omar lopez (AT) jabil (DOT) com> wrote

Omar, here's an post from a while ago...


I've had a corrupt dimension cause the OLAP service to fail before,
but the error message was a standard memory allocation error. If this
is the cause, it's easy to fix - rename the Data folder, create a new
one in it's place and move the catalogs across one at a time ( or
restore from archive ). Make sure toy stop/start OLAP between each one
so you can identify which catalog caused the problem.

More likely it's a bug with the location of the dbghelp dll. We also
had this, and found a fix for it on the MS site somewhere.
A quick google search found this recent posting by Mark Hill -

------------------------------------------------------

The reason for this is that SP3 installs the dll you need to the wrong
directory , so when you have a crash and sqldumper.exe tries to create
a
minudump
it cannot find the correct version of the dbghelp.dll and then it
crashes
.....

You need to take a copy of the dbghelp.dll from your sql server binn
directory and copy this into your analysis services bin directory ,
stop and
start the service.
Next time you get a crash you will get a minidump ....

Also you are likely to have a few instances of this application in
memory if
it has crashed a few times....

Mark Hill

------------------------------------------------------

This fix worked for us, and is much simpler than moving the data
folder and/or restoring the archives.

Good Luck !

Adam