I am trying to create a new Project and I get the following Error:

Insufficient Permissions to create a new SQL Server Report Services at mytfserver\DefaultCollection.

The permissions granted your user name and ID on the SQL Server Reporting Services at mytfserver\DefaultCollection do not allow you create a new project. You must be granted specific permissions by the server administrator.

User Action
Contact the Administrator for the SQL Server Reporting Services at mytfserver\DefaultCollection and ask that the permission "Content Manager" be added to your user Account.

I have checked and double checked. I have given my user all the permissions possible on my Reporting services (Browser, Content Manager, My Reports, Publisher, Report Builder, TFS Content Manager). I have also made my user a "System Administrator" for my Reporting Services.

My user is a member of MyDomain\Domain Admins and I have made that group and my user a local admin on the server and members of the TFS Administrators group. I have also added them to admin the share point services (though that seems to be working alright).

Running Win 2008 SP2: Installed apps: SQL 2008, SCVMM (R1)
   Hosting: Win 2008 SP2: Installed apps: SQL 2008, TFS 2010 (and dependent items)
   Hosting: Windows 7 Ultimate: Installed Apps: Visual Studio Team Suite 2010 (And dependant items) Everything has been freshly installed in the last 48 hours.


as this is a question about TFS 2010 Beta 1, probably best asked where you did in the MSDN forums as more Microsoft product group people monitor that and so any problems you find in the beta product will be more likely to be addressed before the final release.

As you are trying to get this together for a Code Camp demo at the weekend, probably the quickest way to solve it would be to install from scratch (including SQL Server 2008). If you follow the pre-requisite installation instructions carefully then it should work for you - I've installed the beta a few times now using those instructions.

There was an issue in Beta 1 if you don't go straight into the Project Collection creation part after the install wizard - but that was more related to Sharepoint stuff rather than reporting services permissions.

Good luck for your demo.

  • 1
    Drivers for Dell Precision M90 and Windows Server 2008 (R1). PS: I love Radio TFS! – Vaccano Sep 17 '09 at 18:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.