Cannot open database "TfsWarehouse" requested by the login

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.

Solution:

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:

USE [TfsWarehouse]
GO
CREATE USER [NT AUTHORITY\NETWORK SERVICE] FOR LOGIN [NT AUTHORITY\NETWORK SERVICE]
GO
USE [TfsWarehouse]
GO
EXEC sp_addrolemember N'TfsWarehouseDataReader', N'NT AUTHORITY\NETWORK SERVICE'
GO

3. Restart SQL Service and the problem should be resolved.

Hope I can helped.