Author - Ravi Kumar
Reviewed by – Lakhminder Singh
Here is a blog post from the TFS Setup SME, Ravi Kumar. He gives the minimum list of permissions required by the tfssetup account while upgrading TFS particularly from TFS 2005/2008 to TFS 2010 upgrade. Surely, Admins who do not want to give Sys admin role for the account upgrading TFS will like this information.
Server Level Permissions:-
ALTER ANY LOGIN
VIEW ANY DEFINITION
CREATE ANY DATABASE
ALTER ANY DATABASE.
Server Role: - Server Admin
Permissions on Master database:–
Control on Master
Roles on the TFS databases: -
db_owner database role on all the TFS Databases except TfsWarehouse relational database
Member of SharePoint Farm administrator group
db_owner database role for all three SharePoint databases