Can’t start SQL Server Analysis Services clustered instance after changing service account


Symptom


Assume that you have clustered instances in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2. When you change the service account in SQL Server Configuration Manager from the account that was specified during SQL Server setup to a new domain account, you receive an error message that resembles the following in SQL Server Configuration Manager:

Additionally, you can’t start the Microsoft SQL Server Analysis Services clustered instance. When you check the system event log, you see the following error message:

Note The Service shown earlier is for the default instance. For a named instance, the service name is MSOLAP$<instance name>.

Cause


This issue occurs because when you set up the clustered instance of Analysis Services, the service SID isn't granted the "Log on as a service local policy user" right (SeServiceLogonRight).

Resolution


To fix this issue, grant the SQL Server Analysis Services service SID the local policy user "Log on as a service" right.

  • For a default instance of SQL Server Analysis Services, the name of the service SID is NT SERVICE\MSSQLServerOLAPService.
  • For a named instance, the name is NT SERVICE\MSOLAP$<instance name>.

To grant the Log on as a service right to the service SID, follow these steps:

  1. Open Local Security Policy by running the Secpol.msc command.
  2. Expand Local Policies.
  3. Click User Rights Assignment.
  4. In the right pane, right-click Log on as a service, and then click Properties.
  5. Click Add User or Group.
  6. Click the Locations button, select the server name, and then click OK.
  7. In Enter the object names to select box, type NT SERVICE\MSSQLServerOLAPService, and then click OK.

    Note
    For a named instance, instead use MSOLAP$<instance name>.
  8. Click OK.

You must repeat these steps for all nodes in the cluster.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information


This issue only affects clustered instances of Analysis Services for SQL Server 2008 and SQL Server 2008 R2. For Microsoft SQL Server 2012 and later versions of the program, you can't reproduce this issue.