Solved

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

Posted on 2008-10-30
3
2,068 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:dba123
  • 2
3 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 22856825
Accessing the DB from from the actual SERVER itself...meaning...upen up MANAGEMENT STUDIO "on the server" then try and access the DB...

Do the same using your Business Intelligence Development Studio...can you access/run report there?

0
 
LVL 1

Author Comment

by:dba123
ID: 22863153
Problem was that in stupid SharePoint, I extended the website...there's an option to extend a website to another and so by accident I mucked it up.  Fun times.
0
 
LVL 1

Accepted Solution

by:
dba123 earned 0 total points
ID: 22863157
as per the unaccessible Reporting Databases, I needed to turn off UAC or right-click Management Studio and Run As Administrator
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
How to increase the row limit in Jasper Server.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now