After trying what was suggested there (i.e. stsadm –o installfeature –name DiscussionsList) as well as deactiviating/activating/uninstalling/installing features, we finally noticed that the DiscusssionsList Feature.xml last modified was far too recent so we copied a version down from another working server and after reinstalling etc, creation of a site based on the Team Site template worked again, but the TFS error persisted.

Further troubleshooting ensued including, but eventually we tried the SharePoint Inspector as suggested here, which is rather useful for providing a hierarchical and visual drill down of various sharepoint objects. We then ran through all the features used by the TFS site template in question, deactivated/activated etc, but still no change. Eventually it turned out that the IssuesList Feature.xml had also had itself changed somehow, so pulling this down from a working server and doing the same as for the DiscussionsList Feature.xml finally resolved both errors.

The Scope and Hidden settings specifically had been modified, presumably by someone during some previous troubleshooting and/or development. They're built in files so this shouldn't have happened, but hope this at least saves someone else the wasted time and effort.

August 16, 2008

After finally creating my Team Project during my last post, I browsed to my newly created Team Project site, only to find that all reports errored with...

An error has occurred during report processing. (rsProcessingAborted)Cannot create a connection to data source 'TfsOlapReportDS'. (rsErrorOpeningConnection)

After reading this I thought it must be an issue with the cube and so followed the instructions only to find that I had no TfsWarehouse Database listed in Analysis Services at all. I then followed the instructions here and here which seemed to recreate the Database under the SQL Server 2008 Database Engine, but still not under Analysis Services.

I then followed the instructions here in terms of recreating and reprocessing the Database and Cube, which followed by settings the "Connect Using" settings back to what was suggested here now seems to have made everything work.

Shortly after the joy of my last post which was quite prematurely celebrated I ran into this error, the further description of which was...

"The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified."

I then followed the instructions here which in terms of changing the "Connect using" settings for the RS TFS datasources, which has finally led to my Team Project being created properly. Good times.

I was busy configuring a new installation of TFS 2008 running on Windows Server 2008 Standard Edition and SQL Server 2008 Standard Edition and kept receiving this error when trying to create a new Team Project via Team Explorer.

I then tried to log into Reporting Services via Management Studio, only to find that the encryption keys needed to be deleted/restored. After doing this the error continued, but I was able to log into Reporting Services and luckily my TFS datasources were still there (and hopefully unharmed). The error however continued and the actual exception was...

Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'x' are insufficient for performing this operation.