The Event log is logging this error;
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error:An unexpected exception occured..
I went to see the log files SQLDUMPER_ERRORLOG.log in C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log
And I see this every time the service goes down:
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3456
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x01DB20A0
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
05/02/06 14:20:11, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
05/02/06 14:20:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
05/02/06 14:20:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
05/02/06 14:20:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\SQLDmpr0002.mdmp
05/02/06 14:20:21, ERROR , msmdsrv.exe, Unable to open file C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\FlightRecorderCurrent.trc, error 2
05/02/06 14:20:21, ACTION, msmdsrv.exe, Watson Invoke: No
This file: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\FlightRecorderCurrent.trc is not there.
Any ideas?
Thanks,
Matias
Matias