Permissions needed for TFS service account in SQL – for TFS 2012
Server Role – Public
Database Role
· System databases
o Master database – Public, TFSExecRole
· TSF Configuration database – Public,TFSExecRole
· All TFS collection databases - Public, db_datareader, db_datawriter, db_owner and TFSExecRole
· TFS warehouse database – Public, TFSExecRole ( and TfsWarehouseDataReader if the same account is used for reporting by TFS)
· SharePoint Configuration Database (if SharePoint is integrated with TFS) – Public, db_owner
Content Created By: Venkata Narasimhan A
Content Reviewed By: Romit Gulati