Configure the database permissions required by the TFS Server

Original article: http://www.almnetworks.net/zh-CN/post/2010/08/25/Database-Permissions-Required-to-Configure-TFS.aspx

 

Most of the time, there is no problem when we use SQL admin to install the TFS server, but if you want to run into a DBA with a big beard, I am afraid it is not that easy. Many large companies pay great attention to security issues, so we still need to know what permissions TFs requires for installation and configuration.

If you are the one who encounters a big-bearded dBAProgramClerk, please look down:

• To install TFS, you must:ServeradminBecause during TFs configuration, We need to install new system information (system messages ). This operation requires serveradmin role permissions, see: http://msdn.microsoft.com/en-us/library/ms178649.aspx.
• Alter any login, view any definitionServer permissions, because when configuring TFS, We need to query existing SQL users and create a new SQL user name for the service account.
• Control on Master. Permissions on the master database
  • Create role-We need this permission to create tfsexecrole.
  • View Definition-We need the next permission to query the extended attributes of the database.
  • Alter-To install messages, we will delete and recreate the prc_install * messages stored procedures, such as prc_installbuildmessages and prc_installversioncontrolmessage.
  • Execute-We need this permission to execute the prc_install * messages stored procedure.
  • Create Database-We need this permission to create and configure the data mining database.