3

This is a "Answer Your question" type of the post. Just hope the information here will help anyone.

Situation:

  • Migrated TFS from Machine A to Machine B
  • Restored the DB
  • Reconfigured DBs using TfcConfigure RemapDB
  • Changed service account, url, binding and etc.
  • domainname\TFSService = service account to run TFS

Problem:

  • Logged on as the domainname\TFSService
  • Tried to setup "Scheduled backups for TFS" using a domain account used as a service account for running TFS (HOWTO)
  • Back up should be stored on a remote server (accessible over UNC)
  • ERROR = Error “TF400998: The current user failed to retrieve the SQL Server service account information” when trying to configure backup plan in TFS 2015

Question:

  • How to setup the Scheduled Backup using TFSService account?
GrimSmiler
  • 561
  • 1
  • 4
  • 21
  • My issue was solved by giving only the SQL Server hostname (DBSVR) rather giving the SQL server instance name (DBSVR\MSSQLSERVER) – SurenSaluka Jan 24 '22 at 10:19

2 Answers2

2

Solution:

  • Give domainname\TFSService account local Administrator permissions on Your TFS Server
  • Give domainname\TFSService account the sysadmin role in Your SQL Instance used to run TFS
  • Five domainname\TFSService account Log on as a service permissions on the TFS Server (HOWTO)
  • (IMPORTANT!!!) Run SQL Server Service hosting TFS DBs AS domainname\TFSService (HOWTO)
  • (IMPORTANT!!!) Give 'Full permissions' for the account used to run the SQL Service on the UNC destination folder.
  • Example: If SQL Server Account = domainname\TFSService, than permissions on the UNC should also be given to domainname\TFSService

Rerun the TFS "Scheduled Backup" configuration. Should resolve the error.

Sorry if this obvious or straight forward and considered as spam/flooding. Just spent over 3-4 hours. Hopefully this helps people save time and nerves.

GrimSmiler
  • 561
  • 1
  • 4
  • 21
  • had the same issue. did all of the above mentioned steps (not sure I understand what "UNC denstination folder" refers to, but i'm pretty sure that the account had full permissions on it. Anyway, in addition to all of that I had to change the SQL service logon user to be the same user running the TFS service. this is done by opening "services.msc" and changing the logon user of the SQL instance "SQL Server (XXX)" – OSH Jul 11 '17 at 05:32
  • @OSH , sorry. [UNC](https://en.wikipedia.org/wiki/Path_(computing)#Uniform_Naming_Convention) - is the format to the folder path where the backups are stored. What i meant is the folder itself. – GrimSmiler Aug 07 '17 at 18:18
2

In TFS2015 simply make sure that:

  1. Make sure MachineA and MachineB are in the domain and a user "yourDomain\username" is added Application Tier >> Administration Console Users

enter image description here

  1. Take Full Backup Now throw Scheduled Backups and move the backup to MachineB network share, as a restore process might fail throw network.

enter image description here

  1. Open TFS Admin console on MachineB and Remove Application Tier feature if exists.

enter image description here

  1. Use SQL Managment Studio to remove Tfs_configuration and other Tfs_* databases on MachineB

  2. In TFS Admin Console of MachineB, you will have only option to restore under Scheduled Backup.

  3. After restoring process on MachineBLaunch the Application-Tier Onlywizard (right click on Application Tier in TFS Admin Console).In Databases, specify the new SQL Server instance(MachineB/sqlexpress`) where you restored the TFS databases

tobre
  • 1,347
  • 3
  • 21
  • 53
Serge V.
  • 3,377
  • 3
  • 20
  • 28