TFS Service account permissions on Database

by XDK 2. February 2013 13:15


TFS Service account requires the follwoing permissions on TFS - Share Point DBs

APP Database  Roles & Permissions
SQL Server System Master Public and TFSExecRole
TFS Configuration Public and TFSExecRole
TFS Collection Public, db_datareader, db_datawriter, db_owner and TFSExecRole
TFS Warehouse Public, TFSExecRole and TfsWarehouseDataReader
SharePoint Configuration Public and  db_owner

Tags: ,

Team Foundation Server | TFS 2010 | TFS 2012

TF26179 – Field Type 'TreePath' can be used only with System.AreaPath & System.IterationPath – not with custom fields

by XDK 25. January 2013 14:20

The treepath field type supports only system.areapath and system.iterationpath and cannot be used for the custom fields. It’s a limitation


Team Foundation Server | TFS 2010 | TFS 2012

TF10152: The item $/ must remain locked because its file type prevents multiple check-outs.

by XDK 24. January 2013 10:34


Any time a pending change is made to an item, the file types list is checked to see if the extension requires automatic locking at checkout. The idea behind automatic locking is that some file types (images, for example) are hard to merge, and that it may be beneficial to keep two people from working on the same item at the same time.


The list of file extensions is configurable through the Team Explorer by right-clicking the root (server) node and selecting Team Foundation Server Settings → Source Control File Types.




To disable automatic locking by file type, you can find the file extension you're interested in, click Edit... and check the box for "Enable file merging and multiple checkout."

Tags: ,

Team Foundation Server | TFS 2010

The performance counter category ‘Memory’ cannot be accessed on computer ‘COMPUTER1’ (Timed out trying to read performance counter category ‘Memory’ on computer ‘COMPUTER01’); check that the category and computer names are correct.

by XDK 15. January 2013 11:59


Performance Monitor Security settings

The test controller account must be in the Performance Monitor Users group of all machines performance data will be read from. User who is trying to access performance data (locally/remotely) should be part of  ”Performance Monitor Users” and “Performance Log Users”. If there are not much security concerns make the user part of Local “Administrators” group which will ensure full access on the machine.

Load test timeout settings
If permission levels are all fine. But still you are still running into the same issue. That means you have to set load test’s performance counter initialization time out settings. But where to do that? as there is no provision to do it though VS IDE. For that you have to do some manual configurations in load test’s hosting process’s configuration file. Now this configuration file is different for VS 2008 and VS 2010. Following are the details on that.
For Visual Studio 2008, open the file VSTestHost.exe.config in the folder C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE
For Visual Studio 2010, open the file Devenv.exe.config in the folder C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE
AND then add following entries to it. That will solve the timout issue.
      <add key=”LoadTestCounterCategoryReadTimeout” value=”60000″/>
      <add key=”LoadTestCounterCategoryExistsTimeout” value=”60000″/>


Web Performance & Load Tests

Access Denied: User xxx needs Checkin, CheckinOther permission(s)

by XDK 1. January 2013 13:12

The reason is that the build agent account doesn't have permission on your source tree to checkin other user's changes

You need to right click on the source tee in Source Control Explorer. Then click Properties and go to Security tab. You can then select the corresponding user of group and check the Allow checkbox for Check in other user’s changes.


Team Foundation Server | TFS 2010 | TFS 2012

How to increase work item attachments?

by XDK 21. December 2012 13:54


The default value of work item attachments is 4KB.  Attachment size can be adjusted up to 2GB.


Log in as TFS Admin on the TFS Application tier and use the following web services to increase the attachment size.

http://localhost:8080/tfs/<Collection Name>/WorkItemTracking/v1.0/ConfigurationSettingsService.asmx


Team Foundation Server | TFS 2010 | TFS 2012 | TFS 2013

A backup plan already exists for this TFS system on a different machine

by XDK 21. December 2012 11:33


A backup plan already exists for this TFS system on a different machine


The database has an extended property that it stores the name of the machine used for the backups. This was set while running on the original box. You need to remove this value before the power tool will allow you to configure a new backup.


Execute the stored procedure on Tfs_Configuration DB

EXEC sp_dropextendedproperty @name = 'TFS_BACKUP_PLAN_CONTROLLER'


A hotfix that can reduce the size of the test data saved to the TFS database

by XDK 17. December 2012 19:16

Tags: ,

TFS 2010

Security Groups for Test Controller and Agents

by XDK 12. December 2012 11:18

Group Name: TeamTestAgentService

This group contains the minimal permissions needed for a test agent to connect to a test controller.Connect to a test controller
Before you configure a test agent, add the user accounts that you will use to run the test agent service. This is the user account that you specify in the Test Agent Configuration Tool when you install a test agent.

Group Name: TeamTestControllerUsers

Includes permissions from the TeamTestAgentService group.Start test runs.View test results
Add users that only need to run tests and view test results.

Group Name: TeamTestControllerAdmins

Includes permissions from the TeamTestControllerUsers and TeamTestAgentService groups.Delete, pause, or postpone any test run.Add, remove, and change the status of test agents.Create lab environments.
Before you configure a test agent, add the user accounts that you will use to run the test agent service. This is the user account that you specify in the Test Agent Configuration Tool when you install a test agent.


Web Performance & Load Tests

TF14098: Access Denied User [Domain]\User needs Label permission(s) for $/Source

by XDK 8. September 2012 20:14



The users should have project level permission to label any folders and files in version control using visual studio IDE. The error occurs when team project does not have project users/groups permissions set at project level but its set on folders.

Add the users/groups permission at project level.


Tags: , ,

Team Foundation Server


The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.

About the author

My name is Xavier Dilip Kumar Jayaraj and I am a Software Configuration Management Engineer with a background in application development, Build & packaging using Install Shield.

Profile in LinkedIn , PCEP-Certified , Azure-DevOps-C1

DevOps Tools

ALM tools:
Azure DevOps
IBM Rational
CA Agile Central-Rally
CollabNet VersionOne

Configuration tools:
• Puppet
• AWS OpsWorks
• Ansible

Build automation tools:
Apache Ant 
Apache Maven

Continuous Integration tools:

Testing tools:

Version control system tools:
Team Foundation Server

Code review tools:
Bitbucket Server

Continuous Delivery/release management tools:
XL Release
Serena Release
Octopus Deploy

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

Knowledge Base Articles