A few of us were working just this morning on trying to prevent this confusion in the next version, so it seems like a decent time for a blog post. When the TFS 2008 (and 2005 for that matter) setup is asking for "Reporting Services Data Source Account",
