Sql – TFS Reporting and SQL Server 2008 Developer


I have a TFS 2010 beta 2 installation on a server 2008 r2, with a full instalation of sql server 2008 developer with SP1.

I want to enable the reporting capabilities of TFS, but i can't get to connect TFS with analysis services. The app Tier – Reporting – Edit Dialog keeps me saying that the analysis server cannot be reached. I have only one instance of SQL developer (upgraded from express but with everything installed).

I don't know what to do…. Thanks if somebody can help me

Best Solution

Sometimes this error comes up due to access permissions. Analysis services requires for the most part that you use Windows Authentication to connect to it, so make sure that the user that is trying to connect to analysis services has access to it. The easiest way to verify this is to try and connect using SSMS while logged in as the account that you will use to access Analysis Services.