TFS 备份错误

qpzmsxy3819

用TFS进行备份的时候出现如下问题，初步认为是SQL Server没有权限访问网络路径。求高手指导。



PS：TFS服务器机子IP为25，保存在本地机子（即IP为25）的网络路径上是可以的，但是在保存到异地路径（IP为37的机子）的时候出现错误。

以下为错误日志：
[Info   @01:37:20.906]
[Info   @01:37:20.906] +-+-+-+-+-| Starting Verification |+-+-+-+-+-
[Info   @01:37:20.907]
[Info   @01:37:20.907] +-+-+-+-+-| Review Settings |+-+-+-+-+-
[Info   @01:37:20.907] Backup Plan Details
[Info   @01:37:20.907]      Backup Path                             : \\192.168.1.139\MY_ABACKUP\backup
[Info   @01:37:20.907]      Retention Days                          : 30
[Info   @01:37:20.907]      Full Backup Extension                   : bak
[Info   @01:37:20.907]      Transactional Extension                 : trn
[Info   @01:37:20.907]      SMTP Host                               : None
[Info   @01:37:20.907] External Databases
[Info   @01:37:20.907]      Include Reporting Databases             : False
[Info   @01:37:20.907]      Include SharePoint Databases            : True
[Info   @01:37:20.907]      SharePoint Products SQL Server Instance : USER-U6E3P3T74K
[Info   @01:37:20.907]      SharePoint Configuration Database Name  : SharePoint_Config
[Info   @01:37:20.907] Backup Plan Schedules
[Info   @01:37:20.907]      Backup Plan Schedule                    : Nightly Schedule
[Info   @01:37:20.907] Account Information
[Info   @01:37:20.907]      Account                                 : NT Authority\LocalService

…………………………
…………………………
…………………………

[Info   @01:37:30.166] Verify Test Backup Created Successfully
[Info   @01:37:30.167] Starting creating backup test validation
[Error  @01:37:30.920] Microsoft.SqlServer.Management.Smo.FailedOperationException: 备份 对于 服务器“USER-U6E3P3T74K”失败。  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: 执行 Transact-SQL 语句或批处理时发生了异常。 ---> System.Data.SqlClient.SqlException: 无法打开备份设备 '\\192.168.1.139\MY_ABACKUP\backup\temp_20110628093730.bak'。出现操作系统错误 5(拒绝访问。)。
BACKUP DATABASE 正在异常终止。
   在 Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   --- 内部异常堆栈跟踪的结尾 ---
   在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
   在 Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
   在 Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
   在 Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
   --- 内部异常堆栈跟踪的结尾 ---
   在 Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
   在 Microsoft.TeamFoundation.PowerTools.Admin.Helpers.BackupFactory.TestBackupCreation(String path)
[Error  @01:37:30.990] !Verify Error!: Account USER-U6E3P3T74K\Administrator failed to create backups using path \\192.168.1.139\MY_ABACKUP\backup
[Info   @01:37:30.991] "验证: Grant Backup Plan Permissions\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): 退出验证(状态为 Completed，结果为 Error)"
[Info   @01:37:30.991] !Verify Result!: 4 Completed, 0 Skipped: 3 Success, 1 Errors, 0 Warnings
[Info   @01:37:30.992] 验证: Backup Tasks Verifications(VCONTAINER): 开始验证
[Info   @01:37:30.992] A generic container node that does not contribute to results
[Info   @01:37:30.992] "验证: Backup Tasks Verifications(VCONTAINER): 退出验证(状态为 Ignore，结果为 Ignore)"
[Info   @01:37:30.992] 验证: Backup Tasks Verifications\Root(VCONTAINER): 开始验证
[Info   @01:37:30.992] A generic container node that does not contribute to results
[Info   @01:37:30.992] "验证: Backup Tasks Verifications\Root(VCONTAINER): 退出验证(状态为 Ignore，结果为 Ignore)"
[Info   @01:37:30.992] 验证: Backup Tasks Verifications\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): 开始验证
[Info   @01:37:30.992] Verify Test Backup Created Successfully
[Info   @01:37:30.992] Starting creating backup test validation
[Error  @01:37:31.812] Microsoft.SqlServer.Management.Smo.FailedOperationException: 备份 对于 服务器“USER-U6E3P3T74K”失败。  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: 执行 Transact-SQL 语句或批处理时发生了异常。 ---> System.Data.SqlClient.SqlException: 无法打开备份设备 '\\192.168.1.139\MY_ABACKUP\backup\temp_20110628093730.bak'。出现操作系统错误 5(拒绝访问。)。
BACKUP DATABASE 正在异常终止。
   在 Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   --- 内部异常堆栈跟踪的结尾 ---
   在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
   在 Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
   在 Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
   在 Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
   --- 内部异常堆栈跟踪的结尾 ---
   在 Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
   在 Microsoft.TeamFoundation.PowerTools.Admin.Helpers.BackupFactory.TestBackupCreation(String path)
[Error  @01:37:31.883] !Verify Error!: Account USER-U6E3P3T74K\Administrator failed to create backups using path \\192.168.1.139\MY_ABACKUP\backup
[Info   @01:37:31.883] "验证: Backup Tasks Verifications\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): 退出验证(状态为 Completed，结果为 Error)"
[Info   @01:37:31.883] !Verify Result!: 1 Completed, 0 Skipped: 0 Success, 1 Errors, 0 Warnings
[Info   @01:37:31.884]
[Info   @01:37:31.884] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
[Info   @01:37:31.884] Verify Summary
[Info   @01:37:31.884] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
[Info   @01:37:31.884] 2 errors, 1 warnings, 0 skipped, 0 informational
[Info   @01:37:31.884]
[Info   @01:37:31.884] +-+-+-+-+-| Verify Complete. |+-+-+-+-+-

qpzmsxy3819

跪求高手~

qpzmsxy3819

求人才解答下~谢谢！！！！