The installation finished correctly but I still cannot create any project. (I already searched the forum and no luck).

This is the error I am getting:

---begin Exception entry---
Time: 2006-08-23 17:39:03Z
Module: Engine
Event Description: TF30162: Task "Populate Reports" from Group "Reporting" failed
Exception Type: Microsoft.TeamFoundation.Client.PcwException
Exception Message: TF30225: Error uploading report : Work Item with Tasks
Exception Details: The Project Creation Wizard encountered a problem while
creating reports on the SQL Server Reporting Services on MARS.
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.
Stack Trace:
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.UploadReport(ProjectCreationContext context, XmlNode report)
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.HandleCreateReports(ProjectCreationContext context, XmlNode node)
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.Execute(ProjectCreationContext context, XmlNode taskXml)
at Microsoft.VisualStudio.TeamFoundation.ProjectCreationEngine.TaskExecutor.PerformTask(IProjectComponentCreator componentCreator, ProjectCreationContext context, XmlNode taskXml)
at Microsoft.VisualStudio.TeamFoundation.ProjectCreationEngine.RunTask(Object taskObj)
-- Inner Exception --
Exception Type: System.Web.Services.Protocols.SoapException
Exception Message: An internal error occurred on the report server. See the error log for more details. ---> An internal error occurred on the report server. See the error log for more details. ---> EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
SoapException Details: <detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsInternalError</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">An internal error occurred on the report server. See the error log for more details.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsInternalError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=9.00.2047.00</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">9.00.2047.00</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsInternalError" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsInternalError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=9.00.2047.00" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An internal error occurred on the report server. See the error log for more details.</Message><MoreInformation><Source>.Net SqlClient Data Provider</Source><Message>EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.</Message></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>
Stack Trace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.TeamFoundation.Proxy.Reporting.ReportingService.SetCacheOptions(String Report, Boolean CacheReport, ExpirationDefinition Item)
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.UploadReport(ProjectCreationContext context, XmlNode report)
-- end Inner Exception --
--- end Exception entry ---

I already tried the following suggestion:

Hi,

The problem is with uploading a report to the report server. I think you have the correct permissions since you were able to create the site. The problem may have to do with the security settings on the datasources (TfsOlapReportDS and TfsReportDS) as these are the datasources for the reports.

Please verify the following settings: Navigate to the reporting site (/Reports/Pages/Folder.aspx">http://<reportserver>/Reports/Pages/Folder.aspx), click on the TfsOlapReportsDS and the TfsReportDS and verify the connection settings for each, specifically the 'Connect using:' section. This is generally set to 'Credentials stored securely in the report server' and a valid username/password is specified. Also, the 'Use as Windows credentials when connection to the data source' is checked.

-Dennis

Hey AbsoluteIT,

I had the same problem when I tried to update the reports after upgrading from RC to RTM (the reports had been updated between versions). I got around the problem at the time by manually importing the reports one by one from the template. Then I had the exact same problem when I tried to create a new team project. Just when I thought I had removed all problems....

To fix, create a new database role in master and msdb: RSExecRole. In "Securables" add the following:

master:
  xp_sqlagent_notify (execute)
  xp_sqlagent_enum_jobs  (execute)
msdb:
  sp_add_category  (execute)
  sp_verify_job_identifiers  (execute)
  sysjobs (select)

Assign the role from each db to Network Service.

This fixed it for me. Not sure if will work for everyone as each case might be different, but again, it worked for me, I can now create team projects without any errors.

As to why I had this problem - a couple of factors. I had no problems at all with installation. But I deleted the encryption key from Reporting Services since I couldn't remember the passphrase for it, and then created a new encryption key and recreated the datasources etc. Maybe this process removed these permissions on master and msdb???

Enjoy!