我从这篇教程中设置了SQL Server 2008 R2性能工作室数据收集。数据收集似乎非常顺利,但是,当我右键单击“数据收集”-->“报告”-->“管理数据仓库”,然后选择任何要加载的报告时,我会收到以下错误:
如果有人能提供任何帮助,那将对我大有裨益! 最好的祝福, Sebastian
'Failed to connect to server sql1.myserver.com. --< Login failed. The login is from an untrusted domain and cannot be used with Windows Authentication.'
这很奇怪,因为我为MDW设置了一个新的SQL登录,而且我也使用SQL登录登录到SQL Management Studio。查看SQL日志给出了以下结果:
Date 9/14/2011 11:12:13 PM
Log Data Collection (Query Statistics)
Log ID 179
Source Query Statistics
Collection Set Name Query Statistics
Collection Item Name
Status Error
Runtime Execution Mode Upload
Start Time 9/14/2011 11:12:13 PM
Last Iteration Time
Finish Time 9/14/2011 11:12:13 PM
Duration (ms) 0
Operator NT AUTHORITY\SYSTEM
Package Execution ID
Event
Data Code
Message
Failed to connecto to the management data warehouse server Inner Error ------------------>
Row#: 0 Source: "Microsoft SQL Server Native Client 10.0" Instance: "IP-0AAAEEDF" Procedure: "" Line#: 1 Error Number: 18456 Error State: 1 Error Severity: 14 Error Message: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." Help File: "(null)", Help context: 0 GUID: {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}.
OLE DB Error Record dump end.
如果有人能提供任何帮助,那将对我大有裨益! 最好的祝福, Sebastian