Restoring Azure Dev Ops to another server

Keith Lynn 1 Reputation point
2021-09-06T18:41:08.64+00:00

I have an existing Azure Dev Op 2020 setup, and have the full backup from a few days ago. The existing physical server is giving me problems, and I have an Azure Dev Ops installation and SQL Server installation on a different machine. I'm able to access the network shares and see the most recent backup. But after I select the Backup and ask it to verify, I also get a SQL Server issue claiming that the current user cannot login to the database. The only two Azure databases that exist in the instance are for the Configuration and Default Collection. I'm running Azure under user TFSService, and both it and the Administrator account on the machine have SQL logins, and I've made them both owners and administrators on the two databases. But everything I try to verify the backup, it still complains with the error that current user cannot access the database but doesn't specify anything about what user is trying to connect and what the user is trying to connect to. Is there something simple I'm missing in the process?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,104 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dave Patrick 426.3K Reputation points MVP
    2021-09-06T19:29:39.697+00:00

    Devops / TFS is not currently supported here on Q&A. The product group for Azure DevOps / TFS actively monitors questions over at
    https://developercommunity.visualstudio.com/report?space=21&entry=problem
    https://developercommunity.visualstudio.com/report?space=22&entry=problem

    --please don't forget to upvote and Accept as answer if the reply is helpful--

    0 comments No comments