Error while detaching the Collection database : TF246017: Team Foundation Server could not connect to the database.

Environment: TFS 2017 Last weekend while I was with a customer I observed the below error message, it’s interesting to know that this error happened while we were detaching the database to take back up and we could never attach it back again. TF246017: Team Foundation Server could not connect to the database. Verify that…