OLE DB error: OLE DB or ODBC error: Login failed for user
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:
Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to process the Analysis Services database db10073 on the <servername> server. Error: OLE DB error: OLE DB or ODBC error: Login failed for user 'Domain\User'.; 42000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Project Reporting data source', Name of 'Project Reporting data source'. Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'db10073', Name of 'Issue Created Date' was being processed. OLE DB error: OLE DB or ODBC error: Login failed for user 'Domain\User'.; 42000.
The precise set of errors that are emitted will depend on the nature of your cube. The error message string is likely to be very long, with repeating information.
Possible causes
The error can be caused because the account of the service running SQL Server Analysis Services does not have access to the Project Server Reporting database.
Solution
Run the service as a user who has at least 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.