Cannot open database "TfsWarehouse" requested by the login
I Installed TFS 2008 on Server 2008 with SQL 2008, everything during the installation went fine except the reports.
When I tried to process the cube using SSMS I got the following error:
Detailed Message: Cube processing runtime error: \r\nMicrosoft.AnalysisServices.OperationException: Internal error: The operation terminated unsuccessfully.Internal error: The operation terminated unsuccessfully.OLE DB error: OLE DB or ODBC error: Cannot open database "TfsWarehouse" requested by the login. The login failed.; 42000.Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘TfsWarehouseDataSource’, Name of ‘TfsWarehouseDataSource’.Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Run’, Name of ‘Run’ was being processed.Errors in the OLAP storage engine: An error occurred while the ‘Run ID’ attribute of the ‘Run’ dimension from the ‘TfsWarehouse’ database was being processed.
1. SQL management Studio > Database Engine > Databases > TFSWarehouse> Security > Users
and make sure dbo user (administrator) has the tfswarehousedatareader schema checked.
2. Than execute the following script:
CREATE USER [NT AUTHORITY\NETWORK SERVICE] FOR LOGIN [NT AUTHORITY\NETWORK SERVICE]
EXEC sp_addrolemember N’TfsWarehouseDataReader’, N’NT AUTHORITY\NETWORK SERVICE’
3. Restart SQL Service and the problem should be resolved.
Hope I can helped.