We have a TFS 2008 running on a SQL Server 2008 as base (Windows Server 2003 R2 32 Bit Version).
Short time ago I discovered that the Warhouse data (used by reports and analyzer Service) isn't updated. becouse we nearly never used the reports it's broken sinse " September 2010"
If I check the Server logs i find the following event Msg:
Date (UTC): 10.03.2011 11:28:06
Machine: XXXXXXXXXXXXXX
Application Domain: /LM/W3SVC/1048316701/Root/Warehouse-5-129441362809652769
Assembly: Microsoft.TeamFoundation.Warehouse, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 3116
Thread Id: 3268
Account name: ourdomain\generic
Detailed Message: The pending configuration changes were not successfully added to the cube because of the following error:
System.SystemException: The trust relationship between the primary domain and the trusted domain failed.
at System.Security.Principal.NTAccount.TranslateToSids(IdentityReferenceCollection sourceAccounts, Boolean& someFailed)
at System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection sourceAccounts, Type targetType, Boolean& someFailed)
at System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection sourceAccounts, Type targetType, Boolean forceSuccess)
at System.Security.Principal.NTAccount.Translate(Type targetType)
at Microsoft.TeamFoundation.Warehouse.OlapCreator.AddAccountToRole(Role role, String accountName, Boolean needToUpdate)
at Microsoft.TeamFoundation.Warehouse.OlapCreator.SetupAnalysisDatabase(Server server, String analysisDBName, String accessUser, String[] dataReaderAccounts)
at Microsoft.TeamFoundation.Warehouse.OlapCreator.CreateOlap(WarehouseConfig whConf, String accessUser, String[] dataReaderAccounts, Boolean dropDB, Boolean processCube)
at Microsoft.TeamFoundation.Warehouse.AdapterScheduler.EnsureCubeIsUpToDate()
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Somebody have a clue what to do? Restarting the services AND the server didn't helped.