Getting error, while adding TFS service account to the attached database from different environment

Question

Till now we restored configuration database and collection database, then we ran the TFS Config Remap, Prep Clone and change server id. Now I can able to add the configuration database while running app tier only wizard and getting an error

"TF254006: No usable accounts are present in your confirmation database. Use TfsConfig accounts/add to add an account and return to this wizard".

We are getting below error while adding TFS Service account to the attached database from different environment as part of TFS archival/splitting process. TfsConfig Accounts /add /AccountType:ApplicationTier /account: AccountName /SQLInstance: ServerName /DatabaseName: DatabaseName

Error : TF400794: No connection string found for database category 'warehouse'

Answer 1

/SQLInstance: ServerName and /DatabaseName: DatabaseName used only with /ResetOwner, they are not supposed to use with /add.

Add the account to the service account groups for Team Foundation Server. You can simple use:

TFSConfig Accounts /add /AccountType:ApplicationTier /Account:AccountName