none
如何解决用TFS2010备份文件进行恢复时的错误? RRS feed

  • 问题

  • Hi,I met a problem when I experiment  "Restoring TFS Server",I followed the instructions of your article"Backing up and Restoring your TFS Server" (ie"http://blogs.msdn.com/b/bharry/archive/2010/08/18/backing-up-and-restoring-your-tfs-server.aspx").
    It turned out that I restored the sql data into TFS Server B from TFS Server A ,when I looked into the B's sql instance with  sql 2008 management studio. 
    But finally the are errors "Error1:The restore operation for database WSS_Config failed. Please refer to the logs for more information ;
    Error2:The restore operation for database WSS_Content failed. Please refer to the logs for more information ",and the log read "[Error  @02:50:49.980] Microsoft.SqlServer.Management.Common.ConnectionFailureException: 无法连接到服务器/cann't connect to server tfs。 ---> System.Data.SqlClient.SqlException: Login failed for user 'domainname\tfssetup'."  
    I don't know how to deal with this problem ,and look forward to your reply ,thank u sincerely."
    2012年2月9日 8:39

答案

  • Hi jiajia2012,

    Based on the error messages you provided above, I noticed that you get the error: Microsoft.SqlServer.Management.Common.ConnectionFailureException: 无法连接到服务器/cann't connect to server tfs。 ---> System.Data.SqlClient.SqlException: Login failed for user 'domainname\tfssetup'. It seems that the domainname\tfssetup user account does not have access to the WSS_Config database.  Please make sure that user account is a member of the Farm Administratorsgroup for the farm to which the SharePoint Products databases are being restored.

    You can also refer to this article for further information about how to restore TFS databases:

    http://msdn.microsoft.com/en-us/library/ms252458.aspx

    Thanks.


    Vicky Song [MSFT]
    MSDN Community Support | Feedback to us

    • 已标记为答案 jiajia2012 2012年2月15日 9:24
    2012年2月10日 6:11
    版主
  • Restore Data to a Different Server or Instance

    http://msdn.microsoft.com/en-us/library/ms252516.aspx

    http://blog.csdn.net/stamina88

    • 已标记为答案 jiajia2012 2012年2月15日 9:27
    2012年2月15日 9:26

全部回复

  • Hi jiajia2012,

    Based on the error messages you provided above, I noticed that you get the error: Microsoft.SqlServer.Management.Common.ConnectionFailureException: 无法连接到服务器/cann't connect to server tfs。 ---> System.Data.SqlClient.SqlException: Login failed for user 'domainname\tfssetup'. It seems that the domainname\tfssetup user account does not have access to the WSS_Config database.  Please make sure that user account is a member of the Farm Administratorsgroup for the farm to which the SharePoint Products databases are being restored.

    You can also refer to this article for further information about how to restore TFS databases:

    http://msdn.microsoft.com/en-us/library/ms252458.aspx

    Thanks.


    Vicky Song [MSFT]
    MSDN Community Support | Feedback to us

    • 已标记为答案 jiajia2012 2012年2月15日 9:24
    2012年2月10日 6:11
    版主
  • Thank u for your reply:)I add the "domainname\tfssetup" into the Farm Administratorsgroup of server A.However,there is  still the log:"Microsoft.SqlServer.Management.Common.ConnectionFailureException: 无法连接到服务器 TFS。 ---> System.Data.SqlClient.SqlException: Login failed for user 'domainname\tfssetup'."  The server A's account name is "domainname\tfsservice".Both A and B is single mode:TFS Server ,sql server 2008 and sharepoint 3.0 installed in the one server.


    2012年2月15日 6:37
  • yes,yes,thank u very much:) I followed what you said.I add both "domainname\tfsservice" and "domainname\tfssetup" into "WSS_WPG" group of server B,and there is no wrong but one warning as follows :" [Info   @07:22:01.671] Verifies reporting services encryption key can be restored successfully
    [Warning@07:22:02.100] 备份密钥的密码不正确。 (rsBackupKeyPasswordInvalid)
    [Warning@07:22:02.100] !Verify Warning!: Failed to restore Reporting Services encryption key. You can try using RSKEYMGMT command to restore the encryption key "
    2012年2月15日 7:23
  • Restore Data to a Different Server or Instance

    http://msdn.microsoft.com/en-us/library/ms252516.aspx

    http://blog.csdn.net/stamina88

    • 已标记为答案 jiajia2012 2012年2月15日 9:27
    2012年2月15日 9:26