Analysis Services started and then stopped, Event ID: 0xC1210000

I just installed SQL Server 2005 Developer Edition and SP1 and SP2. I cannot start Analysis Services. The message box states: The SQL Server Analysis Services (MSSQLSERVER) service on Local Computer started and then stopped. I looked in the log files located at: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log and found these entries:

msmdsrv.log:

(6/15/2007 10:07:34 AM)
Message: The service cannot be started:
(Source: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\msmdsrv.log,
Type: 3, Category: 289, Event ID: 0xC1210000)
?(6/15/2007 10:10:26 AM) Message:
The service cannot be started:
(Source: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\msmdsrv.log,
Type: 3, Category: 289, Event ID: 0xC1210000)

During installation I did get an unhandled exception (I don't know what component caused the exception). I have found this in the SQLDUMPER_ERRORLOG.log file:

06/14/07 17:39:38, ERROR , msmdsrv.exe, Unable to open file C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\FlightRecorderCurrent.trc, error 2
06/14/07 17:39:38, ACTION, msmdsrv.exe, Watson Invoke: No

Any ideas how to get this service started?

I had the same problem as you discribed. Then I tried to reapply SP2. It works fine now.

I guess when you first applied SP2, analysis service was not installed and therefore the patch is not installed. Download the latest SP2 and try it again:

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en

good luck!

Analysis Services Cube Processing Timing

We are currently using Analysis Services 2000 sp3 on Windows 2003 sp1. We have a large cube that is partitioned and is processed nightly using Parallel Processing utility.

It takes over 4 hours to process that cube, however if the processing is killed after first few minutes and then Olap server is restarted and the cube processing is restarted it only takes 55 minutes.

Has anybody encountered similar situation?

Thank you,

Alex

Looks like you are hitting a timing issue. Try changing number of partitions you process in parallel.

You can also try and upgrade to the latest service pack ( SP4 ).

If still doesn't help, please open a case with Customer Support.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.