Introduction
This article explains how to resolve server startup failures.
Event Viewer Details
This article explains how to resolve server startup failures. Analysis Services Version: SQL Server 2012 Event ID: 1 Source: MSSQLServerOLAPService Message: Service failed to start The MSSQLServerOlapService will not start if it cannot add entries to the application event log. SQL Server 2008 and 2008 R2 customers reported getting this error when the event log was full. This bug does not seem to occur in later versions, or on installations
that have recent service packs applied. To resolve this error immediately, clear the event log or change logging properties to allow overwrite (default): In the Event Viewer, right-click Application Logs and select Clear Log. You will have the option of saving its contents prior to deletion. This error is known to occur if there was a problem installing Analysis Services. To resolve this error, uninstall and re-install Analysis Services to address this problem: MSSQLServerOlapService fails to start, investigate the following potential causes: Port configuration: The service cannot open a port. See
Configure the Windows Firewall to Allow Analysis Services Access for more information. File permissions: The service cannot create or open required files. File permission problems are more likely to occur if you change accounts using scripts or tools that do not update file
permissions when changing a service account. Use SQL Server Configuration Manager to update accounts. See
Configure Service Accounts (Analysis Services) for more information. The following links also reference this error: (log file is full) (master.vmp file is corrupt) Note: Use extreme caution when deleting the master.vmp file. Delete it only if you are fixing an installation problem or are repairing a system that does not have data you care about. The master.vmp file contains the
object GUIDs of all database objects. Deleting it will permanently disable all existing databases, requiring either a database restore or rebuild. See
http://blogs.msdn.com/b/sqlserverfaq/archive/2009/07/08/tampering-master-vmp-file-may-result-in-losing-all-analysis-services-databases.aspx for more information. |