Click here to Skip to main content
13,199,026 members (43,331 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as

Stats

8.4K views
Posted 16 Aug 2014

Error During Configuration of Scheduled Backups for Team Foundation Server

, 16 Aug 2014
Rate this:
Please Sign up or sign in to vote.
Error during configuration of Scheduled Backups for Team Foundation Server

This post Error during configuration of Scheduled Backups for Team Foundation Server written by Manas Bhardwaj appeared first on Manas Bhardwaj's Stream.

Another situation which should be easy and straight forward, but then you realize that it does not work.

I wanted to set up my own Team Foundation Server Express (yes, it’s a light, free version with certain limitations but a good way to start for your small team or organisation). The installation process is quite straight forward and clear.

However, when I wanted to configure the scheduling for back-ups of my TFS database, I was continuously receiving the error below:

TF401009: The TFS service account NT AUTHORITY\LOCAL SERVICE cannot access network shares. Change to an account that can access the backup path.

TF400997: SQL Server service is running as NT AUTHORITY\NetworkService. Please change this account to an account that can be granted permission on the backup path.

Untitled

I had given permissions to both the accounts on the network share. Actually, it was a shared folder on the same machine as I installed the TFS in single server mode.

To add a bit of background, my Team Foundation Service was running under Local Service and SQL Server was running under Network Service. This is the reason why these two accounts come into the picture.

Looking at the logs, it was more clear that for scheduling backups, TFS expects the proper (preferably service) accounts to be used to run SQL Server and Team Foundation Service. The following error messages can be seen in the log.

Verify that account ‘NT AUTHORITY\NetworkService’ is not local service or local system.
Node returned: Error
TF400997: SQL Server service is running as NT AUTHORITY\NetworkService. Please change this account to an account that can be granted permission on the backup path.

And a similar one for TFS Service as well.

Resolution

The resolution is to change the Service account for both SQL Server (MSSQLSERVER) and TFSJobAgent (Visual Studio Team Foundation Background Job Agent) to another account.

Capture

However, this seems to be check only during the configuration. And if you change the service log on user back to Network and Local Service after configuration, the backup procedure still runs without any hassle.

Not sure about the details why this is prevented during configuration. If you are aware of the reason, please share!

This post Error during configuration of Scheduled Backups for Team Foundation Server written by Manas Bhardwaj appeared first on Manas Bhardwaj's Stream.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Manas Bhardwaj
Architect
Netherlands Netherlands

Read my personal blog at www.manasbhardwaj.net.


You may also be interested in...

Pro
Pro

Comments and Discussions

 
PraiseSolved my backup problems Pin
simbakid31-Jul-17 10:26
membersimbakid31-Jul-17 10:26 
GeneralRe: Solved my backup problems Pin
Manas Bhardwaj3-Aug-17 1:46
professionalManas Bhardwaj3-Aug-17 1:46 
PraiseVery Helpful Pin
Member 1328318128-Jun-17 20:00
memberMember 1328318128-Jun-17 20:00 
GeneralRe: Very Helpful Pin
Manas Bhardwaj21-Jul-17 4:53
professionalManas Bhardwaj21-Jul-17 4:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.171020.1 | Last Updated 16 Aug 2014
Article Copyright 2014 by Manas Bhardwaj
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid