SQL

SQL 2014 Setup Failed Analysis Services

SQL 2014 Setup Failed Analysis Services

Recently in building up a SQL 2014 Standard edition VM running on Windows Server 2012 R2, I ran into a peculiar issue with the SQL install with Analysis Services relating to permissions.  The SQL installation went all the way through the process and completed with an error.  After reviewing the error, Analysis Services was the only component that failed to install.

The error in the SQL Setup summary.txt file was as follows:

Feature: Analysis Services
Status: Failed: see logs for details
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Analysis Services
Component error code: 0x80131600
Error description: The service could not be started. Reason: Service 'MSSQLServerOLAPService' start request failed.

After taking a look at the event logs, I saw the following error lurking in the Application log:

sql2k14AS02

This was a plain access denied error indicating file level access problems trying to get to the Data directory I had specified in the SQL install process which resided on the E Drive.

I took a look at the service and of course it was in a stopped state.  The user account that is used for the service to start and perform its functions by default is the NT ServiceMSSQLServerOLAPService account.

sql2k14AS01

What I decided to do was add the account explicitly to the DATA and LOGS directories I had defined in the setup process and allowed the account to modify those directories:

sql2k14AS03

After adding the MSSQLServerOLAPService account to the security ACLS of the directory, the service was then able to start correctly.  I am not sure if this is a bug in the install or if this was unique to my server environment.  Hopefully this will help someone else who may stumble on this issue with installing Analysis Services in SQL 2014.

Subscribe to VirtualizationHowto via Email 🔔

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Brandon Lee

Brandon Lee is the Senior Writer, Engineer and owner at Virtualizationhowto.com and has over two decades of experience in Information Technology. Having worked for numerous Fortune 500 companies as well as in various industries, Brandon has extensive experience in various IT segments and is a strong advocate for open source technologies. Brandon holds many industry certifications, loves the outdoors and spending time with family.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.