TFS Project Creation Failed

In my previous post I mentioned we successfully recovered the TFS from the storage failure, but, recently we hit with another issue while creating the new TFS project.

Issue 1: While trying to create the new TFS project, we got the following error.

TF218027: The following reporting folder could not be created on the server that is running SQL Server Reporting Services: /TfsReports/Collection. The report server is located at: http://<ServerName>/Reports. The error is: TF30063: You are not authorized to access <ServerName>\Collection.. Verify that the path is correct and that you have sufficient permissions to create a folder on that server, and then try again..

The above error was fixed by changing the reporting service to Network Service account from domain account.

Issue 2: We got the following error after the Issue 1 fixed.

Error
TF30224: Failed to retrieve projects from the report server. Please check that the SQL Server Reporting Services Web and Windows services are running and you have sufficient privileges for creating a project.

Explanation
The Project Creation Wizard encountered a problem while creating reports on the SQL Server Reporting Services on http://<ServerName>/ReportServer/ReportService2005.asmx. The reason for the failure cannot be determined at this time. Because the operation failed, the wizard was not able to finish creating the SQL Server Reporting Services site.

User Action
Contact the administrator for the SQL Server Reporting Services on http://<ServerName>/ReportServer/ReportService2005.asmx to confirm that the SQL Server Reporting Services server is running and you have sufficient privileges to create a project . Your user account on SQL Server Reporting Services must have Content Manager permission to create a new project. Also, you might find additional helpful information in the project creation log. The log shows each action taken by the wizard at the time of the failure and may include additional details about the error.

And the log was complaining about the permission issues, with the reports:

Event Description: TF30162: Task "Populate Reports" from Group "Reporting" failed

This issue was fixed by updating the following reporting service data source files will proper credentials.

• Tfs2010OlapReportDS
• Tfs2010ReportDS
• TfsOlapReportDS
• TfsReportDS

With the outage we lost the reporting service encryption key and had to delete all the encrypted content and with that all the connection information in the reporting service data source files were wiped off.