TFS 2012 migrated from TFS 2010: Project Creation fails

As I mentioned previously we migrated to the TFS 2012 + SharePoint 2013. It’s worth to mention that TFS 2012 is just great! It’s so handy to use new dashboards and task planning stuff. We just Love it Smile

But today we had to create new project… and it did work for us.

TF301777: Team Project Creation Failed

New Team Project Wizard encountered the following error and could not continue.

Error

The Project Creation Wizard encountered an error while creating reports to the SQL Server Reporting Services on http://servername/ReportServer/ReportService2005.asmx.

After some Goodling I found Jeremy Jameson blog post on the similar issue. Although our cause was a bit simpler - all the TFS reports were in Reporting Server. So I just had to ran below SQL statements:

USE master
GO
GRANT EXECUTE ON master.dbo.xp_sqlagent_notify TO  [NT SERVICE\ReportServer]
GO
GRANT EXECUTE ON master.dbo.xp_sqlagent_enum_jobs TO  [NT SERVICE\ReportServer]
GO
GRANT EXECUTE ON master.dbo.xp_sqlagent_is_starting TO  [NT SERVICE\ReportServer]
GO
USE msdb
GO
-- Permissions for SQL Agent SP's
GRANT EXECUTE ON msdb.dbo.sp_help_category TO  [NT SERVICE\ReportServer]
GO
GRANT EXECUTE ON msdb.dbo.sp_add_category TO  [NT SERVICE\ReportServer]