While setting up a TFS Backup Plan (part of the TFS 2010 Power Tools) on a new Team Foundation Server, I ran into a security issue.
[ Grant Backup Plan Permissions ] Account tfssetup failed to create backups using path TfsBackups.
I didn’t get rid of this error after making sure that the tfssetup account had the appropriate rights on the shared network folder where the backups will be dropped.
Giving Everyone modifications rights resolved the issue immediately, but of course that’s not the solution I was looking for.
So, ProcessMonitor from SysInternals came once again to the rescue. There I found out that SQL Server (sqlsrvr.exe) was trying to access the shared network folder.
Solution: also grant modifications rights on the shared network folder to the SQLService account that’s running SQL Server.