Project Cube Build Service Analysis Services server connection failure


Applies to: Project Server 2013, Project Server 2010

Topic Last Modified: 2013-12-18

Element ID / Rule Name:   Project_Cube_Build_Service_Analysis_Services_Server_Connection_Failure

Summary:   Microsoft Project Server failed to connect to the Microsoft SQL Server Analysis Services (SSAS) server for building cubes.

Cause:   This error can occur for a number of reasons. Most commonly, this can occur when the SQL Server Analysis Services server is unavailable or the account used to access the Analysis Services server does not have adequate permissions to connect.

Possible resolutions include the following:

  • Ensure that the MSSQLServerOLAPService service (if SQL Server 2000 is used as the back-end database) or SQL Server Analysis Services (if Microsoft SQL Server 2005 is used as the back-end database) is running.

  • Ensure that the account running the Microsoft Project Server Queuing Service is a member of the OLAP Administrators group on the Analysis Services server.