Fixing The TF30255 Error During TFS Project Creation
Over the last few days, I have been struggling with creating a new project on my TFS installation. The project creation operation would fail about 85% of the way through the process with an error which read TF30255: Error uploading report : Work Item With Tasks. Apparently, TFS was attempting to upload report templates to SQL Server 2005 Reporting Services and was failing.
I was finally able to resolve the issue today and wanted to document my fixes:
- add a role called RSExecRole to the master database
- add a role called RSExecRole to the msdb database
- add permissions to the "Securables" section of the RSExecRole in the master database
- add the execute permisssion for the extended stored procedure called xp_sqlagent_notify
- add the execute permisssion for the extended stored procedure called xp_sqlagent_enum_jobs
- add permissions to the "Securables" section of the RSExecRole in the msdb database
- add the execute permisssion for the stored procedure called sp_add_category
- add the execute permisssion for the stored procedure called sp_verify_job_identifiers
- add the select permission for the table called sysjobs
I'm guessing this was something I missed in the TFS Installation Guide. I really need to stop being lazy and read before I install. Thanks goes to this post for helping me out on this thorny problem.
Now I can create a TFS project for Sotue ...