Geeks With Blogs

News TFS is just too much fun not to share. So, along with some of my TFS colleagues, we have organized a local TFS community.
Check us out.
TFS Austin Agile SCM Talk Visual Studio ALM Team Foundation Server Practice

The Problem

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…


The Fix

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.

Posted on Wednesday, February 8, 2012 12:40 PM | Back to top

Comments on this post: TFS 2010 Grant Backup Plan Permissions Error

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Bob Hardister | Powered by: | Join free