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

Comments (0)

Skip to main content