Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Analysis Services doesn't start (2005)

687 views
Skip to first unread message

Mantorok

unread,
Jan 12, 2006, 4:19:28 AM1/12/06
to
Hi

I've installed SQL 2005 on a Windows 2003 server and the Analsysis Services
fails to start - here are the entries in the event log:

1:
The description for Event ID ( 424 ) 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: Message-handling subsystem: The message manager for the default
locale cannot be found. The locale will be changed to US English.
Message-handling subsystem: The message manager for the default locale
cannot be found. The locale will be changed to US English. Errors in the
encryption library: Invalid cryptographic key..

2:
Errors in the metadata manager. An error occurred when instantiating a
metadata object from the file, '\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\VBAMDXINTERNAL.0.asm.xml'.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

3:
The service cannot be started: Message-handling subsystem: The message
manager for the default locale cannot be found. The locale will be changed
to US English. Message-handling subsystem: The message manager for the
default locale cannot be found. The locale will be changed to US English.
Errors in the metadata manager. An error occurred when instantiating a
metadata object from the file, '\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data\VBAMDXINTERNAL.0.asm.xml'. Errors in the encryption
library: Failed to decrypt sensitive data. Possibly the encryption key does
not match or is inaccessible because of improper service account change.
Some server functionality will be inaccesible. Errors in the encryption
library: Failed to encrypt sensitive data. Possibly the encryption key is
inaccessible because of improper service account change.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Any ideas?
Thanks
Kev


goethe

unread,
Jan 27, 2006, 11:07:03 AM1/27/06
to
Try using file explorer and navigate to
>program files
>microsoft sql server
>mssql.2
in this folder you should see a data folder just rename it and create and
empty folder named Data and start your analysis service

sjn

unread,
May 9, 2006, 7:14:01 PM5/9/06
to
Hi,

I have this same issue. In my mssql.2 folder I only have two folders (OLAP &
Reporting Services), no Data Folder. Any suggestions for how to proceed?

Regards
Steve

0 new messages