Can see ReportingService Database in SQL Management Studio  but cannot access/expand it

Original Thread: http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/3b9b7c8c-b94d-4040-b1df-0325658660b0/

Problem:

Ok, so I added Roles and content manager for my domain account on my new TFS server running in Windows 2008.  I created my first project in TFS.  The second time though when I try to create another test project, it goes back to the old security message saying you don't have reporting services permissions to create a project.  I just created one 5 minutes ago!

so I don't get it.

Also, I notice that my Reporting Services databasees are not accessible and are not visible also when you to to mapp a user to databases in sql server security.

Furthermore, I notice that the reports folder in Team Explorer for that first project I created has now a red x on it and is inaccessible.  I don't remember changing a thing after the first project that I was able to create.

Here's the full generic error I get at the very end of the Project Creation Wizard in TFS:

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

Explanation
The Project Creation Wizard encountered a problem while creating reports on the SQL Server Reporting Services on TFS.  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 site.

User Action
Contact the Administrator for the SQL Server Reporting Services on TFS to confirm that the SQL Reporting Services server is running and you have sufficient privilages 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.

Here's the contents of that log file (I x'd out some private stuff for this post) :

2008-10-30 11:16:06Z | Module: Internal | Team Foundation Server proxy retrieved | Completion time: 0.9531921 seconds
2008-10-30 11:16:07Z | Module: Internal | The template information for Team Foundation Server "xxx" was retrieved from the Team Foundation Server. | Completion time: 0.8125572 seconds
2008-10-30 11:16:07Z | Module: Wizard | Retrieved IAuthorizationService proxy | Completion time: 0.2187654 seconds
2008-10-30 11:16:07Z | Module: Wizard | TF30227: Project creation permissions retrieved | Completion time: 0.0156261 seconds
2008-10-30 11:16:26Z | Module: Engine | Thread: 13 | New project will be created with the "MSF for Agile Software Development - v4.2" methodology
2008-10-30 11:16:26Z | Module: Engine | Retrieved IAuthorizationService proxy | Completion time: 0 seconds
2008-10-30 11:16:26Z | Module: Engine | TF30227: Project creation permissions retrieved | Completion time: 0.0156261 seconds
2008-10-30 11:16:26Z | Module: Engine | Wrote compressed process template file | Completion time: 0 seconds
2008-10-30 11:16:28Z | Module: Engine | Extracted process template file | Completion time: 1.2969663 seconds
2008-10-30 11:16:28Z | Module: Engine | Thread: 13 | Starting Project Creation for project "TestProject3" in domain "xxx"
2008-10-30 11:16:28Z | Module: Engine | The user identity information was retrieved from the Group Security Service | Completion time: 0.0156261 seconds
2008-10-30 11:16:28Z | Module: Initializer | Thread: 13 | The New Team Project Wizard is starting to initialize the plug-ins.
2008-10-30 11:16:28Z | Module: CssStructureUploader | Thread: 13 | Entering Initialize in CssStructureUploader
2008-10-30 11:16:28Z | Module: CssStructureUploader | Thread: 13 | Initialize for CssStructureUploader complete
2008-10-30 11:16:28Z | Module: Initializer | Thread: 13 | The New Team Project Wizard successfully Initialized the plug-in Microsoft.ProjectCreationWizard.Classification.
2008-10-30 11:16:28Z | Module: Rosetta | Thread: 13 | Entering Initialize in RosettaReportUploader
---begin Exception entry---
Time: 2008-10-30 11:16:28Z
Module: Initializer
Event Description: TF30207: Initialization for plugin "Microsoft.ProjectCreationWizard.Reporting" failed
Exception Type: Microsoft.TeamFoundation.Client.PcwException
Exception Message: 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.
Exception Details: The Project Creation Wizard encountered a problem while
creating reports on the SQL Server Reporting Services on TFS.
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.CheckForProjectFolder(PrivateData data, String projectName, ProjectCreationContext context)
   at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.Initialize(ProjectCreationContext context)
   at Microsoft.VisualStudio.TeamFoundation.EngineStarter.InitializePlugins(MsfTemplate template, PcwPluginCollection pluginCollection)
--   Inner Exception   --
Exception Type: System.Web.Services.Protocols.SoapException
Exception Message: Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren.
SoapException Details: <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.ListChildren(String Item, Boolean Recursive)
   at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.CheckForProjectFolder(PrivateData data, String projectName, ProjectCreationContext context)
-- end Inner Exception --
--- end Exception entry ---

2008-10-30 11:16:28Z | Module: Engine | Thread: 13 | Attempting to delete MSF folder "C:\Users\xxx\AppData\Local\Temp\TPW_tmp9824.tmp"
2008-10-30 11:16:28Z | Module: Engine | Thread: 13 | The temporary folder C:\Users\xxx\AppData\Local\Temp\TPW_tmp9824.tmp used to store the process template was removed.


Also, in TFS in Team Explorer, when I look at that first project I initially created, the Report folder shows with a red x.  In addition to this, some other observations:

1) I am nto able to expand the ReportServer or ReportServerTemp database in SQL Management Studio 2005.  IT says a generic "the database ReportServer is inaccessible".

2) Then, when I try to go to the properties of any of the logins in SQL Server Security I get a message "One ore more databases are inaccessible and will not be available".  Clearly it's talking about the reporting server databases as they don't show up in the list after I click OK.

The fact that I can't even expand and access the database in SQL Server Management studio is a big problem and I doubt it's normal because we have another server with SSRS and I can access that fine.  I don't think the install is corrupt, as everything has been pretty much ok and this is a brand new server install period.

So I need to figure out why those last 2 messages come up for the ReportServer and ReportServerTemp first and why I can't access them.