After setting up a new instance of TFS I attempting to use the TFS 2010 Power Tools (Dec ‘11) Team Foundation Backups wizard. However, during the Backup Plan Wizard Readiness Checks, the “Grant Backup Plan Permissions” step failed with the error – Account… failed to create backups using path…
Digging into the log created during the Readiness Check I found the following error - Error @xxx Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server 'xxx'. ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Cannot open backup device 'xxx.bak'. Operating system error 1240(The account is not authorized to log in from this station.).
The implication being that something SQL Server is trying to do isn’t working. To get this fixed I:
- Created a small test DB on the SQL Server box
- Attempted to backup this DB to the TFS backup location – this failed
- Attempted to open the backup location folder from the SQL Server machine – this failed
- Investigated as a possible OS/policy issue
- It turns out that this machine’s security policy - Microsoft network client: Digitally sign communications (always) – was enabled.
- Changed this to disabled and rebooted the server
Voila – I was able to validate and create a new backup plan with the wizard.