Reputation: 707
I have two users say user Ad and user Us, Ad has admin rights and is the account used to install and configure TFS 2015, user Us is an admin which has all permissions needed for an administrator.
Now when I tried to create a new project from Visual Studio 2015 the get the below error: Error The Project Creation Wizard encountered an error while creating reports to the SQL Server Reporting Services on
Interestingly, my Ad account does not have SYSDBA permission on the databases when i get the error. But if i provide the SYSDBA permission to the Ad account the project creation utility works.
I want to know how is this possible? and is there a way to create a new project in TFS 2015 without having the SYSDBA permission?
Help appriciated!!!
Upvotes: 1
Views: 1622
Reputation: 78
Permissions for TFS Team project creation: 1. Add the user to TFS Admin console users or to Project collection Admin group 2. If sharepoint is available, Add user to sharepoint Farm admin and also site collection administrators 3. If Reporting is configured, Give user Team Foundation Content Manager role. Still if team project creation fails then Depending on the error check if user is added to TfsReports Folder security and then in to specific collection level folder security. 4. If error is related to Datasources then check if user is available at both reportDS and OlapreportDS security.
If you can give the exact error message base on that recommendations can be made. The above information is the basic requirement.
Upvotes: 0
Reputation: 51183
If you just create a new project, usually you only need to be the memeber of the Project Collection Administrators Group and have the Create new projects permission set to Allow.
However, if you have SQL Server Analysis Services and SQL Server Reporting Services been configured for the deployment or a SharePoint Web application been configured for your deployment, you also need to become a member of Team Foundation Content Managers group and get Full Control permissions on the server that hosts SharePoint Products.
Has SQL Server Analysis Services and SQL Server Reporting Services been configured for the deployment?
If so, ask your administrator to add you as a member of the Team Foundation Content Managers group on the server that hosts SQL Server Reporting Services. Without these permissions, you’ll be unable to create a team project.
More detail info please refer the link from MSDN: Create a team project
Upvotes: 1