MSSQLServerOLAPSevice

all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services are
working excelp OLAP services, i even restarted the server. In service manage
r
it shows 'Starting' on status bar. when i try to connect server through MSA
it gives me error 'cannot open connection to Analysis server the server is
either not started or is too busy', Can anyone help me, it's very urgentThis sounds like it could be related to KB 883656. I have seen this at a cl
ient site, where AS would restart itself every 20-30 seconds, and you will s
ee the state cycle in Service Manager.
There is a hotfix for this bug, and it is also included in the new SP4. In
order to recover from the corrupted state to allow you to apply the service
pack, you'll need to do the following:
1) Using the SQL Server Service Manager, select the MSSQLServerOLAPSer
vice in the second (Services) drop-down list. Uncheck the “Auto-start ser
vice when OS starts” box.
2) Close the Service Manger. Reboot the server to get the restart pro
cess to stop looping.
3) Rename the data folder where Analysis Services stores its databases
. By default, this is c:\Program Files\Microsoft Analysis Services\Data but
it may be different on your system, particularly if there are alternate dri
ves. The folder in question will have subfolders along this structure:
… Data
MyASDatabase
MyCube1
MyCube2
MyCube3
and these lowest level folders will have the many data and aggregate files f
or each cube inside them.
4) Create a new folder in the same directory called Data
5) Restart Analysis Services through the SQL Server Service Manager by
selecting the MSSQLServerOLAPService in the second (Services) drop-down lis
t and clicking the Start icon. Also, check the “Auto-start service when O
S starts” box. Close the Service Manager.
This should get your instance back to normal, the cubes will rebuild from th
e stored metadata next time that you use them. You will need to reprocess.
"Pravin" <Pravin@.discussions.microsoft.com> wrote in message news:64D82324-1604-4627-8A9E-67
186A547AA2@.microsoft.com...
> all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services ar
e
> working excelp OLAP services, i even restarted the server. In service mana
ger
> it shows 'Starting' on status bar. when i try to connect server through M
SA
> it gives me error 'cannot open connection to Analysis server the server is
> either not started or is too busy', Can anyone help me, it's very urgent