Visual TFS Reports setup

Will not work on Windows 7 – See other post in this blog

1. Pre-requisites
   SQL Server 2008 R2 with Reporting Services and Analysis Services
2. Use Team Foundation Administration Console > Application Tier > Reporting
   Edit > Use Reporting ticked > Warehouse Tab > Server (enter name) Database (Tfs_Warehouse)
   Analysis Services Tab > Server (enter name) Database (Tfs_Analysis) Account for accessing data sources Username maybe Domain\User
   Reports Tab > Server (enter name) > Populate URLs Web Service in format http://server:port/ReportServer and Report Manager http://server:port/Reports
   Account for accessing data sources Username maybe Domain\User
   Default Path /TfsReports
3. May need to Use the WarehouseControlWebService.asmx as in Connect link below. Address is
   http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx
   http://connect.microsoft.com/VisualStudio/feedback/details/653006/team-foundation-reports-broken-the-warning-parameter-is-missing-a-value-iterationmdxparam-parameter-is-missing-a-value
4. For me the standard out of the box reports for MSF for Agile.. were missing
   This seems to be because I created the “Visual Studio > Team Explorer > New Team Project ” before setting up TFS reporting.
   First attempt in brackets below. My second attempt was “Visual Studio > Team Explorer > New Team Project > this creates reports for the process of your choice. > Move the reports to the project folder of your choice > Detach the project > Go to Team Foundation Server Administration Console > Team Project Collections > Delete the Team Project”

   (Initially tried to resolve this by finding the Compressed Zip file with the standard reports in. Then uploading the reports into Report Server one by one.
   From the source I had, this had the affect of wrong datasources. After pointing the datasource to the new name Tfs2010ReportDS instead of TfsReportDS this then went further)

5. Bug Status report uploaded send the “Warning” parameter was missing a value.
   First attempt > Manage report > Parameters > Click the web button for Use Default or something like this> Report then ran but had no data
   Second attempt > TFS Administration Console > Reporting > Start Rebuild (takes a while)
   See http://msdn.microsoft.com/en-us/library/cc668753.aspx
   and http://social.msdn.microsoft.com/Forums/en-US/tfsadmin/thread/c8a324ea-c329-41bf-901e-82f464fac4bb

   STILL NOT WORKING. Getting Closer I Feel.

Connect to VS-TFS remotely

This is another great help. Benefits include working more towards a common code library from home or work.

• Connect to VPN
• Visual Studio
  • > Connect to Team Foundation Server
  • Servers
  • Add
  • Use remote network internal i.p address
  • Use default settings
  • May be prompted for Login and password
  • Done > Success
• Or in intenet explorer
  • http:// < internal ip address : <vs-tfs port number default = 8080> /tfs

VS TFS Team Build Process

Install not too bad. Recommendation was to put on a standalone machine or server that would not use too many resources. I picked my spare XP SP3 machine and installed Visual Studio Team Foundation Server 2010. For drop folder I used a server with short directory name \\server-name\Build
Then using Team Explorer in VS from my developer machine I created a Build definition.

First bug was:
user ‘nt authority\network service’ needs write permissions to the path
Solution was go to highest directory add security for Network Service Full Control, but only for that folder
Then for folder Build I also added security for Network Service. This all took sometime.

Now running however next problem was
assemblies not on machine.
Installed on build machine Report Viewer then later VBPowerPacks. Getting better

Next problem was
dll’s below root of build
Solution was to create a “solution folder” called CommonAssemblies and added the required dll’s into this folder. Then Checked these in to Source Code control and pointed projects using these to this folder.

Next problem was
When a program used one assmbly which used another dll build did not work properly. 
Solution was to add dll to last project to build.

———-

Worked great for a day then Build controllers stopped working:
“there was no endpoint listening at http:// … /v3.0/… that would accept the message this is often caused by an incorrect address or soap action”
http://www.ewaldhofman.nl/post/2010/07/14/Build-server-stops-suddenly-and-frequently.aspx
“In my case it turned out that I had a duplicate entry in the DHCP server for the Build Server. Removing the duplicate entry solved the issue.”
DHCP server on PDC server. On inspection I also had duplicate entry in DHCP server. We then a reserved IP address for my XP Build Server machine. This may have helped.
However also in TFS Administration Console changed the “Build Service properties” “Local Build Service Endpoint (incoming):” to use http:// < ip address of machine >

Visual Studio TFS Over a home network ( Team Foundation Server ) ( 2010 )

TFS Team Foundation Services Installation