Login failed for user 'domainName\AnalysisServicesServerName$'
This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.
Topic Last Modified: 2016-11-14
This article describes an error that can occur when you use the Microsoft Office Project Server 2007 Cube Building Service to build or update the OLAP cube database.
Problem description
An error similar to the following appears in the Build Tracking Comments log when you are building or updating the OLAP cube database, during the stage when the OLAP database is being processed:
Login failed for user 'domainName\AnalysisServicesServerName$'.;42000
Possible causes
The error can occur because the account used for the MSSQLServerOLAPService service on the computer on which SQL Server Analysis Services is installed does not have read access to the Project Server Reporting database.
Solution
To resolve the problem, verify that the account used for the MSSQLServerOLAPService service on the computer on which SQL Server Analysis Services is installed has read access to the Reporting database. For more information, see Chapter overview: Configure Office Project Server 2007 to use the Cube Building Service.
Download this book
This topic is included in the following downloadable book for easier reading and printing:
See the full list of available books at Downloadable content for Project Server 2007.