TFS power tools backup plan verify fails with access denied

Question

I am trying to backup from a windows 7 machine with the basic TFS to a machine running VISTA.

 I used the power tool but cannot get past the verify stage.

Please see attached excerpt from the log. Permissions are granted OK but still get access denied?

[Info   @02:56:52.138] Verify: Grant Backup Plan Permissions\Root\VerifySqlServerPermissionsGrantedSuccessfully(VerifySqlServerPermissionsGrantedSuccessfully): Starting Verification

[Info   @02:56:52.138] Verify Sql server Permissions Granted Successfully

[Info   @02:56:52.280] Granting account NT AUTHORITY\LOCAL SERVICE permissions on server dellamd\sqlexpress

[Info   @02:56:52.292] "Verify: Grant Backup Plan Permissions\Root\VerifySqlServerPermissionsGrantedSuccessfully(VerifySqlServerPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @02:56:52.292] Verify: Grant Backup Plan Permissions\Root\VerifySqlDatabasesPermissionsGrantedSuccessfully(VerifySqlDatabasesPermissionsGrantedSuccessfully): Starting Verification

[Info   @02:56:52.292] Verify Sql databases Permissions Granted Successfully

[Info   @02:56:52.353] ModifyExecRole: Add:NT AUTHORITY\LOCAL SERVICE

[Info   @02:56:52.433] result: Noop

[Info   @02:56:52.439] ModifyExecRole: Add:NT AUTHORITY\LOCAL SERVICE

[Info   @02:56:52.504] result: Noop

[Info   @02:56:52.504] "Verify: Grant Backup Plan Permissions\Root\VerifySqlDatabasesPermissionsGrantedSuccessfully(VerifySqlDatabasesPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @02:56:52.504] Verify: Grant Backup Plan Permissions\Root\VerifyBackupPathPermissionsGrantedSuccessfully(VerifyBackupPathPermissionsGrantedSuccessfully): Starting Verification

[Info   @02:56:52.504] Verify backup path Permissions Granted Successfully

[Info   @02:56:52.535] Granting account NT AUTHORITY\NetworkService permission on folder \\DELL09\TFSBackup

[Info   @02:56:52.566] Granting account NT AUTHORITY\LOCAL SERVICE permission on folder \\DELL09\TFSBackup

[Info   @02:56:52.570] Granting the account NT AUTHORITY\LOCAL SERVICE permission on the logs path C:\ProgramData\Microsoft\Team Foundation\Server Configuration

[Info   @02:56:52.571] Granting account NT AUTHORITY\LOCAL SERVICE permission on folder C:\ProgramData\Microsoft\Team Foundation\Server Configuration

[Info   @02:56:52.576] "Verify: Grant Backup Plan Permissions\Root\VerifyBackupPathPermissionsGrantedSuccessfully(VerifyBackupPathPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @02:56:52.576] Verify: Grant Backup Plan Permissions\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): Starting Verification

[Info   @02:56:52.576] Verify Test Backup Created Successfully

[Info   @02:56:52.594] Starting creating backup test validation

[Error  @02:56:53.437] Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server 'DellAMD\SqlExpress'.  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Cannot open backup device '\\DELL09\TFSBackup\temp_20110405195652.bak'. Operating system error 5(Access is denied.).

BACKUP DATABASE is terminating abnormally.

Answer 1

Hi ED,

 

Thanks for your post.

 

Please ensure that the Network Backup Path folder on the Vista machine share and provided the required permission for the NT AUTHORITY\LOCAL SERVICE account.

 

For how to perform backup step by step, please refer to this blog: http://blogs.msdn.com/b/bharry/archive/2010/08/18/backing-up-and-restoring-your-tfs-server.aspx.

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hi John,

 

I think you asked me to ensure that the network backup folder on the Vista machine is shared and provided with the required permission for LOCAL SERVICE.

 

The backup folder folder share on the VISTA machine gives LOCAL SERVICE Full control.

Similarly, the folder properties security tab shows permissions for LOCAL SERVICE set to Full Control.

 

I have read and followed BHarry blog you referenced but get the error as above.

Do you have Brian Harry's email address so I can ask him why it does not work please?

 

Answer 3

Hi ED,

 

Thanks for your reply.

 

This issue is related to the service account for SQL Server service, we need to changing the security permissions on the ‘\\DELL09\TFSBackup’ folder to give the SQL service account (Network Service) write permissions.

 

You can try to create the Backup folder to your local machine which TFS installed, and give the required permission for SQL server account on this local folder, check if it can back up completely.

 

To contact Brian Harry, you can post the comment in this blog.

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 4

Hi John,

 

I created a backup folder on the machine with TFS installed.

I created a backup plan to that folder.

It verified successfully. There was no access denied error.

I ran a full backup and it was also successful.

 

I will now recreate the plan to backup to the remote folder.

As I understand your message, you want me to make sure that

the remote folder security permissions for Network Service are set to

allow write.

 

I will try this and report back shortly

 

Answer 5

Hi John,

 

I checked the TFSbackup folder on the VISTA machine.

 

The backup folder folder share on the VISTA machine has LOCAL SERVICE, and NETWORK SERVICE Full control.

Similarly, the folder properties security tab shows permissions for LOCAL SERVICE, and NETWORK SERVICE set to Full Control.

 

The error is still the same.

Here is the log.

[Info   @18:33:56.824] Verify No Tasks Already Exist

[Warning@18:33:56.830] !Verify Warning!: The following tasks exist and will be deleted:  TfsDeleteOldBackup

[Info   @18:33:56.830] "Verify: Backup Plan Verifications\Root\VerifyNoTasksAlreadyExist(VerifyNoTasksAlreadyExist): Exiting Verification with state Completed and result Warning"

[Info   @18:33:56.830] Verify: Backup Plan Verifications\Root\VerifySqlServiceAccountCanBeGrantedPermission(VerifySqlServiceAccountCanBeGrantedPermission): Starting Verification

[Info   @18:33:56.830] Verify Sql Service Account Can be Granted Permission

[Info   @18:33:56.931] comparing NT AUTHORITY\NetworkService to NT AUTHORITY\SYSTEM, NT AUTHORITY\LOCAL SERVICE and LocalSystem

[Info   @18:33:56.933] "Verify: Backup Plan Verifications\Root\VerifySqlServiceAccountCanBeGrantedPermission(VerifySqlServiceAccountCanBeGrantedPermission): Exiting Verification with state Completed and result Success"

[Info   @18:33:56.933] !Verify Result!: 4 Completed, 0 Skipped: 3 Success, 0 Errors, 1 Warnings

[Info   @18:33:56.939] Verify: Grant Backup Plan Permissions(VCONTAINER): Starting Verification

[Info   @18:33:56.939] A generic container node that does not contribute to results

[Info   @18:33:56.939] "Verify: Grant Backup Plan Permissions(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @18:33:56.939] Verify: Grant Backup Plan Permissions\Root(VCONTAINER): Starting Verification

[Info   @18:33:56.939] A generic container node that does not contribute to results

[Info   @18:33:56.939] "Verify: Grant Backup Plan Permissions\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @18:33:56.939] Verify: Grant Backup Plan Permissions\Root\VerifyLogOnAsBatchJobPermissionGrantedSuccessfully(VerifyLogOnAsBatchJobPermissionGrantedSuccessfully): Starting Verification

[Info   @18:33:56.939] Verify Logon as batch job Permission Granted Successfully

[Info   @18:33:56.943] Skipping granting 'Logon as batch job' for account LocalService

[Info   @18:33:56.943] "Verify: Grant Backup Plan Permissions\Root\VerifyLogOnAsBatchJobPermissionGrantedSuccessfully(VerifyLogOnAsBatchJobPermissionGrantedSuccessfully): Exiting Verification with state Ignore and result Ignore"

[Info   @18:33:56.943] Verify: Grant Backup Plan Permissions\Root\VerifySqlServerPermissionsGrantedSuccessfully(VerifySqlServerPermissionsGrantedSuccessfully): Starting Verification

[Info   @18:33:56.943] Verify Sql server Permissions Granted Successfully

[Info   @18:33:56.972] Granting account NT AUTHORITY\LOCAL SERVICE permissions on server dellamd\sqlexpress

[Info   @18:33:56.974] "Verify: Grant Backup Plan Permissions\Root\VerifySqlServerPermissionsGrantedSuccessfully(VerifySqlServerPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @18:33:56.974] Verify: Grant Backup Plan Permissions\Root\VerifySqlDatabasesPermissionsGrantedSuccessfully(VerifySqlDatabasesPermissionsGrantedSuccessfully): Starting Verification

[Info   @18:33:56.974] Verify Sql databases Permissions Granted Successfully

[Info   @18:33:57.016] ModifyExecRole: Add:NT AUTHORITY\LOCAL SERVICE

[Info   @18:33:57.024] result: Noop

[Info   @18:33:57.028] ModifyExecRole: Add:NT AUTHORITY\LOCAL SERVICE

[Info   @18:33:57.030] result: Noop

[Info   @18:33:57.030] "Verify: Grant Backup Plan Permissions\Root\VerifySqlDatabasesPermissionsGrantedSuccessfully(VerifySqlDatabasesPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @18:33:57.030] Verify: Grant Backup Plan Permissions\Root\VerifyBackupPathPermissionsGrantedSuccessfully(VerifyBackupPathPermissionsGrantedSuccessfully): Starting Verification

[Info   @18:33:57.030] Verify backup path Permissions Granted Successfully

[Info   @18:33:57.061] Granting account NT AUTHORITY\NetworkService permission on folder \\DELL09\TFSBackup

[Info   @18:33:57.065] Granting account NT AUTHORITY\LOCAL SERVICE permission on folder \\DELL09\TFSBackup

[Info   @18:33:57.067] Granting the account NT AUTHORITY\LOCAL SERVICE permission on the logs path C:\ProgramData\Microsoft\Team Foundation\Server Configuration

[Info   @18:33:57.067] Granting account NT AUTHORITY\LOCAL SERVICE permission on folder C:\ProgramData\Microsoft\Team Foundation\Server Configuration

[Info   @18:33:57.072] "Verify: Grant Backup Plan Permissions\Root\VerifyBackupPathPermissionsGrantedSuccessfully(VerifyBackupPathPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @18:33:57.072] Verify: Grant Backup Plan Permissions\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): Starting Verification

[Info   @18:33:57.072] Verify Test Backup Created Successfully

[Info   @18:33:57.089] Starting creating backup test validation

[Error  @18:33:57.533] Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server 'DellAMD\SqlExpress'.  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Cannot open backup device '\\DELL09\TFSBackup\temp_20110408113357.bak'. Operating system error 5(Access is denied.).

BACKUP DATABASE is terminating abnormally.

John, I believe Brian Harry created the backup tool so that simple users moving from VSS to TFS could do so

as simply as possible.

If you could bring this problem to the attention of Brian Harry I think he will be able to explain in simple terms

what the problem is and what I should do to make it work.

 

Answer 6

Hi ED,

 

Thanks for your reply.

 

According your description, you can create the backup plan and perform the full backup successfully on your machine which TFS installed. So it mean that the Power Tools installed correctly and it can works fine.

 

For this issue, it seems only a permission issue. I think that your SQL server installed on the same machine which TFS installed, isn’t it?

 

Please try to follow steps:

1        Please check your SQL Server account, if it’s Network Service.

2        Ensure that the normal communication between your Vista machine and TFS Sever machine.

3        Try to set the folder share for Everyone with the Read/Write permission, then try again.(note the security issue).

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 7

Hi John,

 

Thanks for your reply.

I confirm I can create the backup plan and perform the full backup successfully on my machine on which I intalledTFS

using the BASIC install.

I believe the BASIC TFS install also installed SQL Server (SQLEXPRESS) at the same time on the TFS machine.

I agree that the issue is only a permission issue, but I do not know how to fix it.

The results of the steps you asked me to follow are as follows:

1. On the TFS machine I checked the Service(Local) entry SQL Server(SQLEXPRESS) and the Service name is : MSSQL$SQLEXPRESS

Path "c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe" -sSQLEXPRESS

Log On is is set to account Network Service. I do not know the password as I didn't set it. it is shown as a row of dots.

2. Using 'Start' and selecting Network, I can see the TFS machine (DELLAMD) and the VISTA machine I want to backup to (DELL09).

When I click on DELL09 Windows security asks for a User Name and Password. I enter my user name and password for the VISTA

machine, and I can then see the shared folder, including TFSBackup which I created on Dell09 for the TFS backup.

I can display files that I have copied to this folder from a folder on the DELLAMD machine called tfsbackup.

It was to this folder that the successful backup on the TFS machine was made.

I assume this demonstrates normal communication between the VISTA machine (DELL09) and the Windows 7 TFS machine (DELLAMD).

3. The share permissions on folder TFSBackup on the VISTA machine (DELL09) are set to Full Control for Everyone,

LOCAL SERVICE

NETWORK SERVICE and Administrators(Dell09\Administrators).

The security permissions on folder TFSBackup on the VISTA machine (DELL09) are set to Full Control for Everyone,

LOCAL SERVICE

NETWORK SERVICE

Administrators(Dell09\Administrators) and my user name on the DELL09 machine.

I do not understand the security issues involved!

When I run a backup on the TFS machine I still get the original error. Here is the log output:-

[Info   @20:04:21.588] 

[Info   @20:04:21.589] +-+-+-+-+-| Starting Verification |+-+-+-+-+-

[Info   @20:04:21.599] 

[Info   @20:04:21.599] +-+-+-+-+-| Review Settings |+-+-+-+-+-

[Info   @20:04:21.599] Backup Plan Details

[Info   @20:04:21.599]      Backup Path                  : \\DELL09\TFSBackup

[Info   @20:04:21.599]      Retention Days               : 30

[Info   @20:04:21.599]      Full Backup Extension        : bak

[Info   @20:04:21.599]      Transactional Extension      : trn

[Info   @20:04:21.599]      SMTP Host                    : None

[Info   @20:04:21.599] External Databases

[Info   @20:04:21.599]      Include Reporting Databases  : False

[Info   @20:04:21.599]      Include SharePoint Databases : False

[Info   @20:04:21.599] Backup Plan Schedules

[Info   @20:04:21.599]      Backup Plan Schedule         : Manual Schedule

[Info   @20:04:21.599] Account Information

[Info   @20:04:21.599]      Account                      : NT Authority\LocalService

[Info   @20:04:21.599] 

[Info   @20:04:21.725] Verify: System Checks(VCONTAINER): Starting Verification

[Info   @20:04:21.725] A generic container node that does not contribute to results

[Info   @20:04:21.726] "Verify: System Checks(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:21.728] Verify: System Checks\Root(VCONTAINER): Starting Verification

[Info   @20:04:21.728] A generic container node that does not contribute to results

[Info   @20:04:21.730] "Verify: System Checks\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:21.730] Verify: System Checks\Root\WmiWorks(VWMIWORKS): Starting Verification

[Info   @20:04:21.730] Wmi Works Verification

[Info   @20:04:21.731] Verifying that WMI works on the local machine.

[Info   @20:04:21.758] WMI working on local machine.

[Info   @20:04:21.758] "Verify: System Checks\Root\WmiWorks(VWMIWORKS): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.758] Verify: System Checks\Root\ASLoads(VASLOADS): Starting Verification

[Info   @20:04:21.758] Verifies whether the Analysis Services assembly can load

[Info   @20:04:21.761] "Verify: System Checks\Root\ASLoads(VASLOADS): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.761] !Verify Result!: 2 Completed, 0 Skipped: 2 Success, 0 Errors, 0 Warnings

[Info   @20:04:21.768] Verify: Input Verifications(VCONTAINER): Starting Verification

[Info   @20:04:21.768] A generic container node that does not contribute to results

[Info   @20:04:21.768] "Verify: Input Verifications(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:21.768] Verify: Input Verifications\Root(VCONTAINER): Starting Verification

[Info   @20:04:21.768] A generic container node that does not contribute to results

[Info   @20:04:21.768] "Verify: Input Verifications\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:21.768] Verify: Input Verifications\Root\VerifyBackupPath(BackupPath): Starting Verification

[Info   @20:04:21.768] Verifies that the backup path exists and the path is a network path

[Info   @20:04:21.786] "Verify: Input Verifications\Root\VerifyBackupPath(BackupPath): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.786] Verify: Input Verifications\Root\VerifyRetentionDays(RetentionDays): Starting Verification

[Info   @20:04:21.786] Verifies that the retention days is between 1 and 999 days

[Info   @20:04:21.787] "Verify: Input Verifications\Root\VerifyRetentionDays(RetentionDays): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.787] Verify: Input Verifications\Root\VerifyBackupFileExtension(BackupFileExtension): Starting Verification

[Info   @20:04:21.787] Verifies backup file extensions

[Info   @20:04:21.789] "Verify: Input Verifications\Root\VerifyBackupFileExtension(BackupFileExtension): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.789] Verify: Input Verifications\Root\VerifyTaskSchedulerAccount(VerifyTaskSchedulerAccount): Starting Verification

[Info   @20:04:21.789] Verify Task Scheduler Account

[Info   @20:04:21.792] "Verify: Input Verifications\Root\VerifyTaskSchedulerAccount(VerifyTaskSchedulerAccount): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.792] Verify: Input Verifications\Root\VerifyScheduleTimesAreSynchronized(VerifyScheduleTimesAreSynchronized): Starting Verification

[Info   @20:04:21.792] Verify Schedule Times Are Synchronized

[Info   @20:04:21.795] "Verify: Input Verifications\Root\VerifyScheduleTimesAreSynchronized(VerifyScheduleTimesAreSynchronized): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.795] Verify: Input Verifications\Root\VerifySupportedTaskSchedulerVersion(VerifySupportedTaskSchedulerVersion): Starting Verification

[Info   @20:04:21.795] Verify Supported Task Scheduler Version

[Info   @20:04:21.796] "Verify: Input Verifications\Root\VerifySupportedTaskSchedulerVersion(VerifySupportedTaskSchedulerVersion): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.796] !Verify Result!: 6 Completed, 0 Skipped: 6 Success, 0 Errors, 0 Warnings

[Info   @20:04:21.798] Verify: Database Inspection Verifications(VCONTAINER): Starting Verification

[Info   @20:04:21.798] A generic container node that does not contribute to results

[Info   @20:04:21.798] "Verify: Database Inspection Verifications(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:21.798] Verify: Database Inspection Verifications\Root(VCONTAINER): Starting Verification

[Info   @20:04:21.798] A generic container node that does not contribute to results

[Info   @20:04:21.798] "Verify: Database Inspection Verifications\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:21.798] Verify: Database Inspection Verifications\Root\VerifySuccessfullCollectionDataBasesInspection(DatabaseAccess): Starting Verification

[Info   @20:04:21.798] Verify successfull database inspection.

[Info   @20:04:21.809] Found collection database DefaultCollection

[Info   @20:04:21.809] "Verify: Database Inspection Verifications\Root\VerifySuccessfullCollectionDataBasesInspection(DatabaseAccess): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.809] Verify: Database Inspection Verifications\Root\VerifySuccessfullReportingDataBasesInspection(DataBaseAccess): Starting Verification

[Info   @20:04:21.809] Verify successfull database inspection.

[Info   @20:04:21.813] "Verify: Database Inspection Verifications\Root\VerifySuccessfullReportingDataBasesInspection(DataBaseAccess): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.813] !Verify Result!: 2 Completed, 0 Skipped: 2 Success, 0 Errors, 0 Warnings

[Info   @20:04:21.815] Verify: Backup Plan Verifications(VCONTAINER): Starting Verification

[Info   @20:04:21.815] A generic container node that does not contribute to results

[Info   @20:04:21.815] "Verify: Backup Plan Verifications(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:21.815] Verify: Backup Plan Verifications\Root(VCONTAINER): Starting Verification

[Info   @20:04:21.815] A generic container node that does not contribute to results

[Info   @20:04:21.815] "Verify: Backup Plan Verifications\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:21.815] Verify: Backup Plan Verifications\Root\VerifyConfigIsNotBeingServiced(VerifyConfigIsNotBeingServiced): Starting Verification

[Info   @20:04:21.815] Verify configuration is not currently being serviced

[Info   @20:04:21.818] "Verify: Backup Plan Verifications\Root\VerifyConfigIsNotBeingServiced(VerifyConfigIsNotBeingServiced): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.819] Verify: Backup Plan Verifications\Root\OnePlanPerConfiguration(OnePlanPerConfiguration): Starting Verification

[Info   @20:04:21.819] One Plan Per Configuration

[Info   @20:04:21.822] "Verify: Backup Plan Verifications\Root\OnePlanPerConfiguration(OnePlanPerConfiguration): Exiting Verification with state Completed and result Success"

[Info   @20:04:21.822] Verify: Backup Plan Verifications\Root\VerifyNoTasksAlreadyExist(VerifyNoTasksAlreadyExist): Starting Verification

[Info   @20:04:21.822] Verify No Tasks Already Exist

[Warning@20:04:21.828] !Verify Warning!: The following tasks exist and will be deleted:  TfsDeleteOldBackup

[Info   @20:04:21.828] "Verify: Backup Plan Verifications\Root\VerifyNoTasksAlreadyExist(VerifyNoTasksAlreadyExist): Exiting Verification with state Completed and result Warning"

[Info   @20:04:21.828] Verify: Backup Plan Verifications\Root\VerifySqlServiceAccountCanBeGrantedPermission(VerifySqlServiceAccountCanBeGrantedPermission): Starting Verification

[Info   @20:04:21.828] Verify Sql Service Account Can be Granted Permission

[Info   @20:04:22.331] comparing NT AUTHORITY\NetworkService to NT AUTHORITY\SYSTEM, NT AUTHORITY\LOCAL SERVICE and LocalSystem

[Info   @20:04:22.333] "Verify: Backup Plan Verifications\Root\VerifySqlServiceAccountCanBeGrantedPermission(VerifySqlServiceAccountCanBeGrantedPermission): Exiting Verification with state Completed and result Success"

[Info   @20:04:22.333] !Verify Result!: 4 Completed, 0 Skipped: 3 Success, 0 Errors, 1 Warnings

[Info   @20:04:22.339] Verify: Grant Backup Plan Permissions(VCONTAINER): Starting Verification

[Info   @20:04:22.339] A generic container node that does not contribute to results

[Info   @20:04:22.339] "Verify: Grant Backup Plan Permissions(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:22.339] Verify: Grant Backup Plan Permissions\Root(VCONTAINER): Starting Verification

[Info   @20:04:22.339] A generic container node that does not contribute to results

[Info   @20:04:22.339] "Verify: Grant Backup Plan Permissions\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:22.339] Verify: Grant Backup Plan Permissions\Root\VerifyLogOnAsBatchJobPermissionGrantedSuccessfully(VerifyLogOnAsBatchJobPermissionGrantedSuccessfully): Starting Verification

[Info   @20:04:22.339] Verify Logon as batch job Permission Granted Successfully

[Info   @20:04:22.343] Skipping granting 'Logon as batch job' for account LocalService

[Info   @20:04:22.343] "Verify: Grant Backup Plan Permissions\Root\VerifyLogOnAsBatchJobPermissionGrantedSuccessfully(VerifyLogOnAsBatchJobPermissionGrantedSuccessfully): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:22.343] Verify: Grant Backup Plan Permissions\Root\VerifySqlServerPermissionsGrantedSuccessfully(VerifySqlServerPermissionsGrantedSuccessfully): Starting Verification

[Info   @20:04:22.343] Verify Sql server Permissions Granted Successfully

[Info   @20:04:22.463] Granting account NT AUTHORITY\LOCAL SERVICE permissions on server dellamd\sqlexpress

[Info   @20:04:22.465] "Verify: Grant Backup Plan Permissions\Root\VerifySqlServerPermissionsGrantedSuccessfully(VerifySqlServerPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @20:04:22.465] Verify: Grant Backup Plan Permissions\Root\VerifySqlDatabasesPermissionsGrantedSuccessfully(VerifySqlDatabasesPermissionsGrantedSuccessfully): Starting Verification

[Info   @20:04:22.465] Verify Sql databases Permissions Granted Successfully

[Info   @20:04:22.507] ModifyExecRole: Add:NT AUTHORITY\LOCAL SERVICE

[Info   @20:04:22.572] result: Noop

[Info   @20:04:22.578] ModifyExecRole: Add:NT AUTHORITY\LOCAL SERVICE

[Info   @20:04:22.633] result: Noop

[Info   @20:04:22.633] "Verify: Grant Backup Plan Permissions\Root\VerifySqlDatabasesPermissionsGrantedSuccessfully(VerifySqlDatabasesPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @20:04:22.633] Verify: Grant Backup Plan Permissions\Root\VerifyBackupPathPermissionsGrantedSuccessfully(VerifyBackupPathPermissionsGrantedSuccessfully): Starting Verification

[Info   @20:04:22.633] Verify backup path Permissions Granted Successfully

[Info   @20:04:22.665] Granting account NT AUTHORITY\NetworkService permission on folder \\DELL09\TFSBackup

[Info   @20:04:22.704] Granting account NT AUTHORITY\LOCAL SERVICE permission on folder \\DELL09\TFSBackup

[Info   @20:04:22.713] Granting the account NT AUTHORITY\LOCAL SERVICE permission on the logs path C:\ProgramData\Microsoft\Team Foundation\Server Configuration

[Info   @20:04:22.714] Granting account NT AUTHORITY\LOCAL SERVICE permission on folder C:\ProgramData\Microsoft\Team Foundation\Server Configuration

[Info   @20:04:22.719] "Verify: Grant Backup Plan Permissions\Root\VerifyBackupPathPermissionsGrantedSuccessfully(VerifyBackupPathPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @20:04:22.719] Verify: Grant Backup Plan Permissions\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): Starting Verification

[Info   @20:04:22.719] Verify Test Backup Created Successfully

[Info   @20:04:22.744] Starting creating backup test validation

[Error  @20:04:23.666] Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server 'DellAMD\SqlExpress'.  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Cannot open backup device '\\DELL09\TFSBackup\temp_20110412130422.bak'. Operating system error 5(Access is denied.).

BACKUP DATABASE is terminating abnormally.

   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

   --- End of inner exception stack trace ---

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)

   at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)

   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

   --- End of inner exception stack trace ---

   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

   at Microsoft.TeamFoundation.PowerTools.Admin.Helpers.BackupFactory.TestBackupCreation(String path)

[Error  @20:04:24.076] !Verify Error!: Account DellAMD\Edward C. Kirkman failed to create backups using path \\DELL09\TFSBackup

[Info   @20:04:24.076] "Verify: Grant Backup Plan Permissions\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): Exiting Verification with state Completed and result Error"

[Info   @20:04:24.076] !Verify Result!: 4 Completed, 0 Skipped: 3 Success, 1 Errors, 0 Warnings

[Info   @20:04:24.077] Verify: Backup Tasks Verifications(VCONTAINER): Starting Verification

[Info   @20:04:24.077] A generic container node that does not contribute to results

[Info   @20:04:24.077] "Verify: Backup Tasks Verifications(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:24.077] Verify: Backup Tasks Verifications\Root(VCONTAINER): Starting Verification

[Info   @20:04:24.077] A generic container node that does not contribute to results

[Info   @20:04:24.077] "Verify: Backup Tasks Verifications\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @20:04:24.077] Verify: Backup Tasks Verifications\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): Starting Verification

[Info   @20:04:24.077] Verify Test Backup Created Successfully

[Info   @20:04:24.077] Starting creating backup test validation

[Error  @20:04:24.512] Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server 'DellAMD\SqlExpress'.  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Cannot open backup device '\\DELL09\TFSBackup\temp_20110412130424.bak'. Operating system error 5(Access is denied.).

BACKUP DATABASE is terminating abnormally.

   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

   --- End of inner exception stack trace ---

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)

   at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)

   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

   --- End of inner exception stack trace ---

   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

   at Microsoft.TeamFoundation.PowerTools.Admin.Helpers.BackupFactory.TestBackupCreation(String path)

[Error  @20:04:24.609] !Verify Error!: Account DellAMD\Edward C. Kirkman failed to create backups using path \\DELL09\TFSBackup

[Info   @20:04:24.609] "Verify: Backup Tasks Verifications\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): Exiting Verification with state Completed and result Error"

[Info   @20:04:24.609] !Verify Result!: 1 Completed, 0 Skipped: 0 Success, 1 Errors, 0 Warnings

[Info   @20:04:24.623] 

[Info   @20:04:24.623] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

[Info   @20:04:24.623] Verify Summary

[Info   @20:04:24.623] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

[Info   @20:04:24.623] 2 errors, 1 warnings, 0 skipped, 0 informational

[Info   @20:04:24.623] 

[Info   @20:04:24.623] +-+-+-+-+-| Verify Complete. |+-+-+-+-+-

 

Answer 8

Hi ED,

 

Thanks for your reply.

 

You said that you enter your user name and password for the VISTA machine, then you can see the share folder. I think this is the problem.

 

The DELLAMD is the machine which TFS installed, the DELL09 is the VISTA machine which you create a share TFSBackup folder on it. If you want to backup TFS to this TFSBackup folder on DELL09, you should  can do that click Start on your DELLAMD machine and input \\DELL09\TFSBackup in the search box to open the TFSBackup folder directly, without any authentication(username and password).

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 9

Hi John,

 

Thanks for your reply.

 

1. I clicked Start on DELLAMD machine and input\\DELL09\TFSBackup in the search box to open the TFSBackup folder.

It opened without asking for my user name and password......

 

2. I used the Team Foundation Administration Console to attempt to recreate the Backup Plan to  use \\DELL09\TFSBackup.

 

This failed as before???

 

Does the log not indicate the error well enough???

 

Here is the log.

 

[Info   @21:21:16.443] 

[Info   @21:21:16.454] +-+-+-+-+-| Starting Verification |+-+-+-+-+-

[Info   @21:21:16.464] 

[Info   @21:21:16.464] +-+-+-+-+-| Review Settings |+-+-+-+-+-

[Info   @21:21:16.464] Backup Plan Details

[Info   @21:21:16.464]      Backup Path                  : \\DELL09\TFSBackup

[Info   @21:21:16.464]      Retention Days               : 30

[Info   @21:21:16.464]      Full Backup Extension        : bak

[Info   @21:21:16.464]      Transactional Extension      : trn

[Info   @21:21:16.464]      SMTP Host                    : None

[Info   @21:21:16.464] External Databases

[Info   @21:21:16.464]      Include Reporting Databases  : False

[Info   @21:21:16.464]      Include SharePoint Databases : False

[Info   @21:21:16.464] Backup Plan Schedules

[Info   @21:21:16.464]      Backup Plan Schedule         : Manual Schedule

[Info   @21:21:16.464] Account Information

[Info   @21:21:16.465]      Account                      : NT Authority\LocalService

[Info   @21:21:16.465] 

[Info   @21:21:16.614] Verify: System Checks(VCONTAINER): Starting Verification

[Info   @21:21:16.614] A generic container node that does not contribute to results

[Info   @21:21:16.615] "Verify: System Checks(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:16.617] Verify: System Checks\Root(VCONTAINER): Starting Verification

[Info   @21:21:16.617] A generic container node that does not contribute to results

[Info   @21:21:16.617] "Verify: System Checks\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:16.618] Verify: System Checks\Root\WmiWorks(VWMIWORKS): Starting Verification

[Info   @21:21:16.618] Wmi Works Verification

[Info   @21:21:16.619] Verifying that WMI works on the local machine.

[Info   @21:21:16.688] WMI working on local machine.

[Info   @21:21:16.688] "Verify: System Checks\Root\WmiWorks(VWMIWORKS): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.688] Verify: System Checks\Root\ASLoads(VASLOADS): Starting Verification

[Info   @21:21:16.688] Verifies whether the Analysis Services assembly can load

[Info   @21:21:16.691] "Verify: System Checks\Root\ASLoads(VASLOADS): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.691] !Verify Result!: 2 Completed, 0 Skipped: 2 Success, 0 Errors, 0 Warnings

[Info   @21:21:16.716] Verify: Input Verifications(VCONTAINER): Starting Verification

[Info   @21:21:16.716] A generic container node that does not contribute to results

[Info   @21:21:16.716] "Verify: Input Verifications(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:16.716] Verify: Input Verifications\Root(VCONTAINER): Starting Verification

[Info   @21:21:16.716] A generic container node that does not contribute to results

[Info   @21:21:16.716] "Verify: Input Verifications\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:16.716] Verify: Input Verifications\Root\VerifyBackupPath(BackupPath): Starting Verification

[Info   @21:21:16.716] Verifies that the backup path exists and the path is a network path

[Info   @21:21:16.724] "Verify: Input Verifications\Root\VerifyBackupPath(BackupPath): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.724] Verify: Input Verifications\Root\VerifyRetentionDays(RetentionDays): Starting Verification

[Info   @21:21:16.724] Verifies that the retention days is between 1 and 999 days

[Info   @21:21:16.725] "Verify: Input Verifications\Root\VerifyRetentionDays(RetentionDays): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.725] Verify: Input Verifications\Root\VerifyBackupFileExtension(BackupFileExtension): Starting Verification

[Info   @21:21:16.725] Verifies backup file extensions

[Info   @21:21:16.727] "Verify: Input Verifications\Root\VerifyBackupFileExtension(BackupFileExtension): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.728] Verify: Input Verifications\Root\VerifyTaskSchedulerAccount(VerifyTaskSchedulerAccount): Starting Verification

[Info   @21:21:16.728] Verify Task Scheduler Account

[Info   @21:21:16.730] "Verify: Input Verifications\Root\VerifyTaskSchedulerAccount(VerifyTaskSchedulerAccount): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.730] Verify: Input Verifications\Root\VerifyScheduleTimesAreSynchronized(VerifyScheduleTimesAreSynchronized): Starting Verification

[Info   @21:21:16.730] Verify Schedule Times Are Synchronized

[Info   @21:21:16.734] "Verify: Input Verifications\Root\VerifyScheduleTimesAreSynchronized(VerifyScheduleTimesAreSynchronized): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.734] Verify: Input Verifications\Root\VerifySupportedTaskSchedulerVersion(VerifySupportedTaskSchedulerVersion): Starting Verification

[Info   @21:21:16.734] Verify Supported Task Scheduler Version

[Info   @21:21:16.735] "Verify: Input Verifications\Root\VerifySupportedTaskSchedulerVersion(VerifySupportedTaskSchedulerVersion): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.735] !Verify Result!: 6 Completed, 0 Skipped: 6 Success, 0 Errors, 0 Warnings

[Info   @21:21:16.739] Verify: Database Inspection Verifications(VCONTAINER): Starting Verification

[Info   @21:21:16.739] A generic container node that does not contribute to results

[Info   @21:21:16.739] "Verify: Database Inspection Verifications(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:16.739] Verify: Database Inspection Verifications\Root(VCONTAINER): Starting Verification

[Info   @21:21:16.739] A generic container node that does not contribute to results

[Info   @21:21:16.739] "Verify: Database Inspection Verifications\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:16.739] Verify: Database Inspection Verifications\Root\VerifySuccessfullCollectionDataBasesInspection(DatabaseAccess): Starting Verification

[Info   @21:21:16.739] Verify successfull database inspection.

[Info   @21:21:16.753] Found collection database DefaultCollection

[Info   @21:21:16.754] "Verify: Database Inspection Verifications\Root\VerifySuccessfullCollectionDataBasesInspection(DatabaseAccess): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.754] Verify: Database Inspection Verifications\Root\VerifySuccessfullReportingDataBasesInspection(DataBaseAccess): Starting Verification

[Info   @21:21:16.754] Verify successfull database inspection.

[Info   @21:21:16.758] "Verify: Database Inspection Verifications\Root\VerifySuccessfullReportingDataBasesInspection(DataBaseAccess): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.758] !Verify Result!: 2 Completed, 0 Skipped: 2 Success, 0 Errors, 0 Warnings

[Info   @21:21:16.759] Verify: Backup Plan Verifications(VCONTAINER): Starting Verification

[Info   @21:21:16.759] A generic container node that does not contribute to results

[Info   @21:21:16.759] "Verify: Backup Plan Verifications(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:16.759] Verify: Backup Plan Verifications\Root(VCONTAINER): Starting Verification

[Info   @21:21:16.759] A generic container node that does not contribute to results

[Info   @21:21:16.759] "Verify: Backup Plan Verifications\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:16.760] Verify: Backup Plan Verifications\Root\VerifyConfigIsNotBeingServiced(VerifyConfigIsNotBeingServiced): Starting Verification

[Info   @21:21:16.760] Verify configuration is not currently being serviced

[Info   @21:21:16.763] "Verify: Backup Plan Verifications\Root\VerifyConfigIsNotBeingServiced(VerifyConfigIsNotBeingServiced): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.763] Verify: Backup Plan Verifications\Root\OnePlanPerConfiguration(OnePlanPerConfiguration): Starting Verification

[Info   @21:21:16.763] One Plan Per Configuration

[Info   @21:21:16.768] "Verify: Backup Plan Verifications\Root\OnePlanPerConfiguration(OnePlanPerConfiguration): Exiting Verification with state Completed and result Success"

[Info   @21:21:16.768] Verify: Backup Plan Verifications\Root\VerifyNoTasksAlreadyExist(VerifyNoTasksAlreadyExist): Starting Verification

[Info   @21:21:16.768] Verify No Tasks Already Exist

[Warning@21:21:16.774] !Verify Warning!: The following tasks exist and will be deleted:  TfsDeleteOldBackup

[Info   @21:21:16.774] "Verify: Backup Plan Verifications\Root\VerifyNoTasksAlreadyExist(VerifyNoTasksAlreadyExist): Exiting Verification with state Completed and result Warning"

[Info   @21:21:16.774] Verify: Backup Plan Verifications\Root\VerifySqlServiceAccountCanBeGrantedPermission(VerifySqlServiceAccountCanBeGrantedPermission): Starting Verification

[Info   @21:21:16.774] Verify Sql Service Account Can be Granted Permission

[Info   @21:21:17.405] comparing NT AUTHORITY\NetworkService to NT AUTHORITY\SYSTEM, NT AUTHORITY\LOCAL SERVICE and LocalSystem

[Info   @21:21:17.410] "Verify: Backup Plan Verifications\Root\VerifySqlServiceAccountCanBeGrantedPermission(VerifySqlServiceAccountCanBeGrantedPermission): Exiting Verification with state Completed and result Success"

[Info   @21:21:17.410] !Verify Result!: 4 Completed, 0 Skipped: 3 Success, 0 Errors, 1 Warnings

[Info   @21:21:17.416] Verify: Grant Backup Plan Permissions(VCONTAINER): Starting Verification

[Info   @21:21:17.416] A generic container node that does not contribute to results

[Info   @21:21:17.416] "Verify: Grant Backup Plan Permissions(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:17.416] Verify: Grant Backup Plan Permissions\Root(VCONTAINER): Starting Verification

[Info   @21:21:17.416] A generic container node that does not contribute to results

[Info   @21:21:17.416] "Verify: Grant Backup Plan Permissions\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:17.416] Verify: Grant Backup Plan Permissions\Root\VerifyLogOnAsBatchJobPermissionGrantedSuccessfully(VerifyLogOnAsBatchJobPermissionGrantedSuccessfully): Starting Verification

[Info   @21:21:17.416] Verify Logon as batch job Permission Granted Successfully

[Info   @21:21:17.420] Skipping granting 'Logon as batch job' for account LocalService

[Info   @21:21:17.420] "Verify: Grant Backup Plan Permissions\Root\VerifyLogOnAsBatchJobPermissionGrantedSuccessfully(VerifyLogOnAsBatchJobPermissionGrantedSuccessfully): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:17.420] Verify: Grant Backup Plan Permissions\Root\VerifySqlServerPermissionsGrantedSuccessfully(VerifySqlServerPermissionsGrantedSuccessfully): Starting Verification

[Info   @21:21:17.420] Verify Sql server Permissions Granted Successfully

[Info   @21:21:17.625] Granting account NT AUTHORITY\LOCAL SERVICE permissions on server dellamd\sqlexpress

[Info   @21:21:17.647] "Verify: Grant Backup Plan Permissions\Root\VerifySqlServerPermissionsGrantedSuccessfully(VerifySqlServerPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @21:21:17.647] Verify: Grant Backup Plan Permissions\Root\VerifySqlDatabasesPermissionsGrantedSuccessfully(VerifySqlDatabasesPermissionsGrantedSuccessfully): Starting Verification

[Info   @21:21:17.647] Verify Sql databases Permissions Granted Successfully

[Info   @21:21:17.719] ModifyExecRole: Add:NT AUTHORITY\LOCAL SERVICE

[Info   @21:21:17.797] result: Noop

[Info   @21:21:17.803] ModifyExecRole: Add:NT AUTHORITY\LOCAL SERVICE

[Info   @21:21:17.852] result: Noop

[Info   @21:21:17.852] "Verify: Grant Backup Plan Permissions\Root\VerifySqlDatabasesPermissionsGrantedSuccessfully(VerifySqlDatabasesPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @21:21:17.852] Verify: Grant Backup Plan Permissions\Root\VerifyBackupPathPermissionsGrantedSuccessfully(VerifyBackupPathPermissionsGrantedSuccessfully): Starting Verification

[Info   @21:21:17.852] Verify backup path Permissions Granted Successfully

[Info   @21:21:17.885] Granting account NT AUTHORITY\NetworkService permission on folder \\DELL09\TFSBackup

[Info   @21:21:17.924] Granting account NT AUTHORITY\LOCAL SERVICE permission on folder \\DELL09\TFSBackup

[Info   @21:21:17.940] Granting the account NT AUTHORITY\LOCAL SERVICE permission on the logs path C:\ProgramData\Microsoft\Team Foundation\Server Configuration

[Info   @21:21:17.940] Granting account NT AUTHORITY\LOCAL SERVICE permission on folder C:\ProgramData\Microsoft\Team Foundation\Server Configuration

[Info   @21:21:17.946] "Verify: Grant Backup Plan Permissions\Root\VerifyBackupPathPermissionsGrantedSuccessfully(VerifyBackupPathPermissionsGrantedSuccessfully): Exiting Verification with state Completed and result Success"

[Info   @21:21:17.946] Verify: Grant Backup Plan Permissions\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): Starting Verification

[Info   @21:21:17.946] Verify Test Backup Created Successfully

[Info   @21:21:17.964] Starting creating backup test validation

[Error  @21:21:18.782] Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server 'DellAMD\SqlExpress'.  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Cannot open backup device '\\DELL09\TFSBackup\temp_20110413142117.bak'. Operating system error 5(Access is denied.).

BACKUP DATABASE is terminating abnormally.

   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

   --- End of inner exception stack trace ---

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)

   at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)

   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

   --- End of inner exception stack trace ---

   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

   at Microsoft.TeamFoundation.PowerTools.Admin.Helpers.BackupFactory.TestBackupCreation(String path)

[Error  @21:21:18.954] !Verify Error!: Account DellAMD\Edward C. Kirkman failed to create backups using path \\DELL09\TFSBackup

[Info   @21:21:18.954] "Verify: Grant Backup Plan Permissions\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): Exiting Verification with state Completed and result Error"

[Info   @21:21:18.954] !Verify Result!: 4 Completed, 0 Skipped: 3 Success, 1 Errors, 0 Warnings

[Info   @21:21:18.959] Verify: Backup Tasks Verifications(VCONTAINER): Starting Verification

[Info   @21:21:18.959] A generic container node that does not contribute to results

[Info   @21:21:18.959] "Verify: Backup Tasks Verifications(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:18.959] Verify: Backup Tasks Verifications\Root(VCONTAINER): Starting Verification

[Info   @21:21:18.959] A generic container node that does not contribute to results

[Info   @21:21:18.959] "Verify: Backup Tasks Verifications\Root(VCONTAINER): Exiting Verification with state Ignore and result Ignore"

[Info   @21:21:18.960] Verify: Backup Tasks Verifications\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): Starting Verification

[Info   @21:21:18.960] Verify Test Backup Created Successfully

[Info   @21:21:18.960] Starting creating backup test validation

[Error  @21:21:19.397] Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server 'DellAMD\SqlExpress'.  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Cannot open backup device '\\DELL09\TFSBackup\temp_20110413142118.bak'. Operating system error 5(Access is denied.).

BACKUP DATABASE is terminating abnormally.

   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

   --- End of inner exception stack trace ---

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)

   at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)

   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

   --- End of inner exception stack trace ---

   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

   at Microsoft.TeamFoundation.PowerTools.Admin.Helpers.BackupFactory.TestBackupCreation(String path)

[Error  @21:21:19.485] !Verify Error!: Account DellAMD\Edward C. Kirkman failed to create backups using path \\DELL09\TFSBackup

[Info   @21:21:19.485] "Verify: Backup Tasks Verifications\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): Exiting Verification with state Completed and result Error"

[Info   @21:21:19.485] !Verify Result!: 1 Completed, 0 Skipped: 0 Success, 1 Errors, 0 Warnings

[Info   @21:21:19.500] 

[Info   @21:21:19.500] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

[Info   @21:21:19.500] Verify Summary

[Info   @21:21:19.500] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

[Info   @21:21:19.500] 2 errors, 1 warnings, 0 skipped, 0 informational

[Info   @21:21:19.500] 

[Info   @21:21:19.500] +-+-+-+-+-| Verify Complete. |+-+-+-+-+-

Answer 10

Hi ED,

 

Thanks for your reply.

 

Try to open the folder path \\DELL09\TFSBackup on DELLAMD machine using Widows Explorer, check if it can be open correctly.

 

When the error occurred, on DELL09 machine, under Widows Event Viewer, open the Security log, check that which specific account be access denied.

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 11

Hi John,

 

Thanks for your reply.

 

1. I clicked Start on DELLAMD machine and used Windows Explorer Network DELL09 to display \\DELL09\TFSBackup and to open the TFSBackup folder.

It opened ok without asking for my user name and password......

 

2. I used the Team Foundation Administration Console to attempt to recreate the Backup Plan to  use \\DELL09\TFSBackup.

It failed as above. On the DELL09 machine I used Event Viewer to open the security log. I saw nothing recorded regarding ACCESS DENIED.

How do I turn on the security logging of ACCESS DENIED???

Answer 12

Hi ED,

 

Thanks for your reply.

 

If there have security errors, them will be display in Security log, needn’t we to turn on something.

 

Try to install the TFS Power Tools on DELL09 machine, then click Start>>All Programs>>TFS Power Tools>>TFS Backup Plan>>Backup Plan Restore Wizard to create the backup on DELL09 machine, setting the UNC path is \\DELL09\TFSBackup .

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 13

Hi John,

 

1. I do not understand your sentence

"If there have security errors, them will be display in Security log, needn’t we to turn on something."

2. Can I install TFS power tools on DELL09 when it does not have TFS???

How will this help?

 

3. Did you check why this problem occurs with Brian Harry, as he wrote the tool????

If not please do so as we are losing so much time.

 

4. Do you have an estimate of how long it will take you to solve this problem?

 

5. If you cannot solve this problem, please escalate to someone who can.

Thank you

 

Answer 14

Hi ED,

 

Thanks for your reply.

 

The TFS Power Tools didn’t write by Brian Harry.

 

I said in my previous reply, you can created the backup plan and perform the full backup successfully on your machine where TFS installed, so I think the Power Tools installed correctly and it can works fine.

 

According the errors in your log:

1        System.Data.SqlClient.SqlException: Cannot open backup device’\\...’.  

2        Account DellAMD\Edward C.Kirkman failed to create backups using path \\DELL09\TFSBackup

 

These two errors both just relate to permission, so I suggestion contact permission experts directly to resolve this issue. 

 

Thanks for your understanding.

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 15

Hi John,

 

Thanks for your reply.

Brian Harry wrote the back up tool in the TFS power tools.

Do you know where I can contact a permissions expert to solve this problem?

 

Thank you.

Answer 16

Hi John,

 

Thanks for your reply.

Brian Harry wrote the back up tool in the TFS power tools.

Do you know where I can contact a permissions expert to solve this problem?

 

Thank you.

I guess there is nobody interested in helping .....................

Sounds about right for Microsoft.

 

Ed

 

 

 

 

 

 

 

Answer 17

Hi John,

The problem is not solved and I would be grateful if you would not mark it as answered until it is successfully dealt with.

If you can't give a solution please pass to someone who can (e.g. Brian Harry)

 

Answer 18

Ed,

I am having this exact same problem. I have given "Everyone" full control priveledges on my network share and still getting the exact same error message.

Can anyone provide more information?

Answer 19

Hi Ekoostik,

I have given up trying to get the backup running to a network drive.

Clearly a problem of permissions but seems even the Microsoft 'experts' can't sort

out how to solve what should be a trivial problem.

So many 'experts', so little help.....

I bought an additional external drive working over esata, and it does the job.

 

Good luck!

Ed

 

Answer 20

Hi Ed,

Sorry you are having troubles with the tool. I can work with you on the issue you are seeing.

What account is sql services running as? If the backup shared folder is remote and sql services are running as Network Service, could you please ensure the domain\machineName$ account has permission on the shared folder?

Thanks,

Marwa

 

---

Marwa

Answer 21

Hi Marwa,

I have no idea what account sql services is running as, or even if it is running.

 

I am on a small workgroup network, and was using Visual Source Safe until told that

TFS had been given a basic instal option and worked with Visual Studio 2010.

I presume the basic instal installed SQL?

If you can give me very explicit instuctions on what to check I will do so.

 

Thanks,

 

Ed

 

Answer 22

Hi Ed,

Sorry for getting back to you late on this. The basic installation installs SQL Express for you.

You should be able to check the service account from the Services panel (click Start, then click Run, type in services.msc and click Enter, find SQL Server (SLQL Express) and check the account it is running as)

Where is the backup folder located? Is it on a remote share?  

Please let me know if you have questions.

Thanks,

Marwa

---

Marwa

Answer 23

Hi Marwa,

The same situation is with my scenario. Please find below points in brief:

On one server we have SQL Server 2008 R2, TFS 2010

For SQL Server(MSSQLSERVER) instance we have given local user authentication, in this case its my login [e-mail] as if I will let it be Local System account then Power tool will not allow it.

For backup destination folder I have tried by keeping full permissions for EVERYONE \ My Login \ NETWORK SERVICE account, but it failed all the way. :(

Can you please guide on this.....

Answer 24

I am getting the same error:

"Account XXX\XXX failed to create backups using path \\XXXXXX"

The path is set to full control for EVERYONE.

Thanks,

Alan

Answer 25

Hi,

I created a folder on the same server as TFS Server and shared it.  Assigned appropriate permissions and now it is working.

Alan

Answer 26

After getting my permissions setup properly I had the same problem.

What fixed it for me was I had a shared drive labeled as J$

so my shared drive was //32435-wq-233/J$ <----- THis did not work.

So I created a folder on this shared drive called Backups and gave my service accounts the correct read/write permissions on that folder.

I then set the backup Plan's back unc path to //32435-wq-233/Backups

BINGO WORKED LIKE A CHARM.

 

---

Thanks

Answer 27

I too have had this same issue and I belive I know why.  This happens because the account SQL server uses to perform backups does not by default have rights to this remote folder you are backing up to.

Firstly, identify the SQL server account that it uses to perform backups by finding your regular SQL Server backup or data folder - this differs from version to version.  I have the 64 bit edition of SQL Server 2008 R2 for example, and my backup / data folder is located in:

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL

Right click that folder and check the permissions under the security tab:

That account hilighted in the picture is the SQL server account used to perform backups etc.  THAT is the account that needs permission to the remote folder.  The problem with this is that if that folder is indeed on a remote PC and you are not on an Active Directory domain but a workgroup setup, you cannot afford rights to a folder on a remote computer to this (local) user.  If you are on an active directory setup, I imagine it is possible to assign these rights, but I can't see any way to do it in a workgroup environment.

If anyone can use that information to solve the issue, I'd be grateful.  For now I am backing up to the local machine and using synctoy to copy those files across to the remote location - not the most elegant solution but it'll have to do for now.

Answer 28

Finally here is some other workaround:

*) Login with TFS Installation account \ Service account

*) Create new folder for backup destination.

*) Assign full security permission to itself

*) Check owner of folder again. It should be the same account

*) include INHERITABLE permissions from object's parent.

*) MSSQLSERVER service logon account should be same account.

NOW, run TFS Backup Wizard n Try...

Good Luck!

Answer 29

So I was having this exact same issue, but in mine, I found that the problem was I was using a hidden share (F$ in this instance).  Even though I am on a domain environment, and the account I was using for the backup had full control and admin on the remote machine that the backups were to go to, I was still getting access is denied.  I found that the solution was to create a non-hidden share on the remote machine 'TFS_Backup' and set everyone to full control on the share permissions, then ensure that my domain account had full control on the remote location's NTFS permissions, and this fixed the issue.  So if anyone is using the a hidden share in the remote network path, remove that and setup a path that does not have a hidden share.

Cheers.  ^_^

Answer 30

Hi Marwa,

Thanks for this suggestion. In my case I had created a shared folder (called Backups) on my backup server (SERVER\Backups) and a sub folder within this share (SERVER\Backups\TFSBackups).

The problem with the tool is that it grants permissions to the sub folder instead of the actual share!

I had to grant permission to the share to:

DOMAIN\MACHINENAME$ as you mentioned above

NETWORK SERVICE so that SQL Server could write to the folder

Seems to be working now. Must monitor for some time to be sure

Thanks

Arvin

Answer 31

The same issue!!! The following solved my problem : (Assume : TFS Server name is SERVER and Filing Server is SERVER2)

1- Make a backup via Network Service Account (in TFS PowerTools console settings)

2- Run ALL my SQL SERVICES (DB,Analysis,Reporting,...) via a domain account (here is : TfsSqlServiceAdmin )which is member if administrators and all related auto genreated SQL Server Groups

3- Set full permission for the the remote folder (here is : \\SERVER\tfsbackups)  for : Administrators, Local Service , Network Service and SQL Services' runner account (here: TfsSqlServiceAdmin) and the most important thing : The computer which runs TFS (here :mydomain.com\SERVER2$)

4- Also set the full sharing access for the above accounts too.

I think the golden points are step 1 and setting access to the TFS computer(step 3 & 4). BTW the above settings solved my problem after two days of wasting time :-)

---

Mahmoud Moravej

Answer 32

word

Answer 33

I'm using 2012 now and having the same issue. Despite the TFS and SQLServer related accounts have been granted full access and fully shared, it does not work.

I went through all the answers, there is nothing new there. Any additional suggestions?