Wednesday, September 16, 2015

How to Resolve SSAS Service Failed to Start Issue

After you installed SQL Server 2012 on your Windows Server, if you changed default directory which stored the SSAS database, your SSAS Service will fail to start.

If you go to windows event viewer, check the event with mistake, you will find associated error information like this:

This error happened because the account which launch the SSAS service doesn't have enough privilege to write the new directory.

So the fix is easy. Simply go to the directory, right click on the directory, choose properties, and select Security Tab, add the account which will launch the SSAS service, and click OK. After you successfully added the account, choose the account, and click on Edit button,  add Full Control and Modify for the account, finally click OK.

Then you can restart your SASS Service successfully.

I think this is SSAS package cliche at SQL Server 2012 with BI option. It seemed Microsoft never thought to fix it. :)

No comments:

Post a Comment