TFS 2015 Restoration failure

Question

I've a backup from one TFS server and I'm trying to restore it on another server. But i'm getting this error. Please help.

TF400998: The current user failed to retrieve the SQL Server service account information from tfssvnsvr. Please make sure you have permissions to retrieve this information.

TF246017: Team Foundation Server could not connect to the database. Verify that the instance is specified correctly, that the server that is hosting the database is operational, and that network problems are not blocking communication with the server.

Please don't hesitate to ask any questions for more clarifications — SurenSaluka, Feb 18 '16 at 13:39
Can you connect from SQL Manager on the TFS server to the database? Sounds like it is a firewall or other network issue... Or permissions. — MrHinsh - Martin Hinshelwood, Feb 19 '16 at 11:51
Then its permissions. Does the Tfs Service account have SysAdmin on the database ? — MrHinsh - Martin Hinshelwood, Feb 19 '16 at 12:26
I'm new to this, could you please tell me in detail where to look and what to do — SurenSaluka, Feb 19 '16 at 12:27
http://stackoverflow.com/questions/14814798/how-to-add-sysadmin-login-to-sql-server — MrHinsh - Martin Hinshelwood, Feb 19 '16 at 12:47
Yes I've added domain admin and tfs service account both as the admin in the sql server — SurenSaluka, Feb 19 '16 at 12:50

score 1 · Answer 1 · answered Feb 22 '16 at 07:52

To perform Restore Database procedures, you must be a member of the following groups or have the following permissions:

A member of the Administrators security group on the server.
Either a member of the SQL Server System Administrator security group, or your SQL Server Perform Back Up and Create Maintenance Plan permission must be set to Allow.
A member of the sysadmin security group for the databases for Team Foundation.
If the deployment uses SharePoint Products, a member of the Farm Administrators group for the farm to which the SharePoint Products databases are being restored.

More information of Restore a deployment to new hardware, you can refer to: https://msdn.microsoft.com/en-us/library/hh529826(v=vs.120).aspx

TFS 2015 Restoration failure

1 Answers1