Able to create First Project, but Now I can't!!

Question

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.

I'm frustrated.

---

C# Web Developer

Answer 1

Hi NoEgo,

Just  a quick question. Did you ad Roles and content manager after you created the first project but before you attempted the second?

Sorry this has been frustrating. Hopefully, we can quickly resolve this issue,

--Aaron

Answer 2

Thanks.

I created a new role assignment in the site-wide security settings for my domain account.  Administrator was already added by either TFS or SSRS.
I also Added my domain account to Home | Properties Tab and gave myself content manager rights.  Again, Administrator was already setup there.

And my assumption is that the context trying to create this new project is me..as I am logged into this TFS server and it's not Network Service which is the account we have configured to run several of the services (SRS, TFS(TFSService), etc.) ??   Otherwise I'm totally stuck and baffled as to why I was able to create an initial project but now, I get the TFS 30224 error I described above and I checked to make sure my domain account has content manager rights in SSRS security in the web manager (http://localhost/reports)

I am running Windows Server 2008, TFS 2008, SharePoint 2007, and SQL 2005 here

---

C# Web Developer

Answer 3

Is it possible to roll back each of the new roles and try to create a project again (so that we can try to figure out which of these roles caused the problem)?

Also, one more question, are you trying to create a project with the same name as a previous project that has been deleted from the system?


--Aaron

Answer 4

One more thing,

Could you post the entire error message here?

Thanks,

--Aaron

Answer 5

Thanks a lot.  Sure, I can recreate the Administrator in security and properties as well as my domain login.

I'm definitely creating a new project with a different project name.  I even tried 2 variations.

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.

---

C# Web Developer

Answer 6

also, I noticed a more descriptive error message when I try to go to properties of the ReportServer database in SQL Management Studio

TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server principal "xxx\mynetworkid" is not able to access the database "ReportServer" under the current security context. (Microsoft SQL Server, Error: 916)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476


So I don't get it.  I'm setup as a local admin and in SQL Server, I have rights to every other database because local admins has access to those other databases and I explicitely also added my account as well in Security to all other databases.  Why I can't see ReportServer databases in User mappings is beyond me.

---

C# Web Developer

Answer 7

Actually just now I checked out the roles.  Since I'm part of the builtin\Administrators and this group was added to the sysadmin role, I should be fine.  But just for kicks I tried to add my domain account to the sysAdmin role in SQL Server and got an error saying I don't have permission to add myself basically.

---

C# Web Developer

Answer 8

Hi NoEgo,

I hate to say this, but it looks like the problem is in SQL Reporting Services. As a result, you'll probably have better luck getting a response in the SQL forums. You can find the microsoft SQL forums here http://forums.microsoft.com/TechNet/default.aspx?ForumGroupID=93&SiteID=17 

In paricular, the the SQL Server Database Engine Forum, located here, http://forums.microsoft.com/TechNet/ShowForum.aspx?ForumID=93&SiteID=17 has previously answered a similar question to yours. (The URL for this particular thread is http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3580275&SiteID=17 )

In addition, you might find the following two articles useful:

http://support.microsoft.com/kb/315523

http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.tools&tid=50aa1cf1-9db2-40c7-8820-83436924437c&cat=en_us_95f1e6f2-be99-45d5-bcd9-4851e0c957fd&lang=en&cr=us&sloc=&p=1

If you don't get any traction in the SQL forum, please let me know.

I'm sorry we can't be of more help. If you have any more questions, feel free to ask, and hopefully, we can more fully answer them.

Good Luck,

--Aaron

Answer 9

Since you are running Windows 2008 being part of the administrators group does not give you admin access on SQL Server.  Did you specifically add your account using the SQL Server 2005 Surface Area Configuration Tool?  Maybe when you created the project the first time you launched Visual Studio as Administrator.

Wes

Answer 10

I am admin on the Server 2008 and also the local admin group has rights in SQL Server as well in the SQL Security to specific databases so I'm covered.  UAC was the problem.  Either disable it or make sure you run as administrator when opening Management Studio

---

C# Web Developer

Answer 11

I had the same problem because i installed TFS 2008 with integrated SP1.

The solution was to reinstall Visual Studio 2008 SP1, and run as administrator, of course.