tfs - Team Foundation 无法从 Team Foundation Server 检索团队项目列表

Question

当我尝试连接到 tfs 时，出现以下错误:

---------------------------
Microsoft Visual Studio
---------------------------
Team Foundation Server

TF31001: Team Foundation cannot retrieve the list of team projects from Team Foundation Server UGSERVER. The Team Foundation Server returned the following error: Team Foundation services are not available from the server.

Technical information (for administrator):

TF30059: Fatal error while initializing web service.

然后，我检查了事件查看器，它具有以下详细信息:

Event Type:    Error
Event Source:    TFS Services
Event Category:    None
Event ID:    3017
Date:        2/2/2010
Time:        9:38:31 AM
User:        N/A
Computer:    UGSERVER
Description:
TF53010: The following error has occurred in a Team Foundation component or extension:
Date (UTC): 2/2/2010 4:38:31 AM
Machine: UGSERVER
Application Domain: /LM/W3SVC/738167904/Root/Services-11-129095591107656250
Assembly: Microsoft.TeamFoundation.Server, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
  Process Name: w3wp
  Process Id: 408
  Thread Id: 6020
  Account name: NT AUTHORITY\LOCAL SERVICE

Detailed Message: TF53013: A crash report is being prepared for Microsoft. The following information is included in that report:
System Values
OS Version Information=Microsoft Windows NT 5.2.3790 Service Pack 2, v.2845
CLR Version Information=2.0.50727.1433
Machine Name=UGSERVER Processor Count=2
Working Set=52858880
System Directory=C:\WINDOWS\system32
Process Values
ExitCode=0
Interactive=False
Has Shutdown Started=False
Process Environment Variables
Path = C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;D:\Program Files\Microsoft SQL Server\90\DTS\Binn\;D:\Program Files\Microsoft SQL Server\90\Tools\binn\;D:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;C:\Program Files\Microsoft Team Foundation Server 2008 Power Tools\;C:\Program Files\Microsoft Team Foundation Server 2008 Power Tools\Best Practices Analyzer\
TEMP = C:\WINDOWS\TEMP
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE = x86
SystemDrive = C:
windir = C:\WINDOWS
TMP = C:\WINDOWS\TEMP
ALLUSERSPROFILE = C:\Documents and Settings\All Users
TFSPowerToolDir = C:\Program Files\Microsoft Team Foundation Server 2008 Power Tools\
USERPROFILE = C:\Documents and Settings\Default User
ProgramFiles = C:\Program Files
FP_NO_HOST_CHECK = NO
COMPUTERNAME = UGSERVER
APP_POOL_ID = Microsoft Team Foundation Server Application Pool
NUMBER_OF_PROCESSORS = 2
PROCESSOR_IDENTIFIER = x86 Family 15 Model 4 Stepping 1, GenuineIntel
ClusterLog = C:\WINDOWS\Cluster\cluster.log
SystemRoot = C:\WINDOWS
ComSpec = C:\WINDOWS\system32\cmd.exe
CommonProgramFiles = C:\Program Files\Common Files
PROCESSOR_LEVEL = 15
PROCESSOR_REVISION = 0401
lib = C:\Program Files\SQLXML 4.0\bin\
BPADir = C:\Program Files\Microsoft Team Foundation Server 2008 Power Tools\Best Practices Analyzer\
VS90COMNTOOLS = d:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\
OS = Windows_NT

Request Details
Url=http://ugserver:8080/Services/v1.0/ServerStatus.asmx [method = POST]
User Agent=Team Foundation (devenv.exe, 9.0.21022.8)
Headers=Content-Length=354&Content-Type=text%2fxml%3b+charset%3dutf-8&Accept-Encoding=gzip%2cgzip%2cgzip&Accept-Language=en-US&Authorization=NTLM+TlRMTVNTUAADAAAAAAAAAEgAAAAAAAAASAAAAAAAAABIAAAAAAAAAEgAAAAAAAAASAAAAAAAAABIAAAANcKI4gUCzg4AAAAP&Expect=100-continue&Host=ugserver%3a8080&User-Agent=Team+Foundation+(devenv.exe%2c+9.0.21022.8)&X-TFS-Version=1.0.0.0&X-TFS-Session=8d9f4a30-16f3-4fc6-8daa-3aaefd2a8ea6&SOAPAction=%22http%3a%2f%2fschemas.microsoft.com%2fTeamFoundation%2f2005%2f06%2fServices%2fServerStatus%2f03%2fCheckAuthentication%22
Path=/Services/v1.0/ServerStatus.asmx
Local Request=True
User Host Address=192.168.1.186
User=UGSERVER\Administrator [auth = NTLM]

Application Provided Information
Team Foundation Application Information
Event Log Source = TFS Services
Configured Team Foundation Server = http://UGSERVER:8080
License Type = EnterpriseLicense
Server Culture = en-US
Activity Logging Name = Integration
Component Name = CS
Initialized = No
Requests Processed = 0


Exception: SqlException
Message: Cannot open database "TfsIntegration" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
SQL Exception Class: 11
SQL Exception Number: 4060
SQL Exception Server: UGSERVER\UGSERVER
SQL Exception Source: .Net SqlClient Data Provider
SQL Exception State: 1
SQL Exception Procedure:
SQL Exception Line Number: 65536
SQL Error: System.Data.SqlClient.SqlError: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
    Class: 14
    Number: 18456
    Server: UGSERVER\UGSERVER
    Source: .Net SqlClient Data Provider
    State: 1
    Procedure:
    Line Number: 65536
Exception Data Dictionary follows
HelpLink.ProdName = Microsoft SQL Server
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 4060
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476
Stack Trace:
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.TeamFoundation.RegistrationDataAccessor.GetRegisteredTools(String toolId, String connectionString)
   at Microsoft.TeamFoundation.RegistrationDataAccessor.GetRegistrationEntries(String toolId, String connectionString)
   at Microsoft.TeamFoundation.Server.RegistrationEventSchemaProvider..ctor(String applicationPath)
   at Microsoft.TeamFoundation.Server.CombinationEventSchemaProvider..ctor(String applicationPath)
   at Microsoft.TeamFoundation.Server.Global.Initialize()
   at Microsoft.TeamFoundation.Server.TeamFoundationApplication.Init()

Application Domain Information
Assembly Name=mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Assembly CLR Version=v2.0.50727
Assembly Version=2.0.0.0
Assembly Location=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll
Assembly File Version:
File:             C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll
InternalName:     mscorlib.dll
OriginalFilename: mscorlib.dll
FileVersion:      2.0.50727.1433 (REDBITS.050727-1400)
FileDescription:  Microsoft Common Language Runtime Class Library
Product:          Microsoft® .NET Framework
ProductVersion:   2.0.50727.1433
Debug:            False
Patched:          False
PreRelease:       False
PrivateBuild:     False
SpecialBuild:     False
Language:         English (United States)

Assembly Name=System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Assembly CLR Version=v2.0.50727
Assembly Version=2.0.0.0
Assembly Location=C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll
Assembly File Version:
File:             C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll
InternalName:     System.Web.dll
OriginalFilename: System.Web.dll
FileVersion:      2.0.50727.1433 (REDBITS.050727-1400)
FileDescription:  System.Web.dll
Product:          Microsoft® .NET Framework
ProductVersion:   2.0.50727.1433
Debug:            False
Patched:          False
PreRelease:       False
PrivateBuild:     False
SpecialBuild:     False
Language:         English (United States)

Assembly Name=System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Assembly CLR Version=v2.0.50727
Assembly Version=2.0.0.0
Assembly Location=C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll
Assembly File Version:
File:             C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll
InternalName:     System.dll
OriginalFilename: System.dll
FileVersion:      2.0.50727.1433 (REDBITS.050727-1400)
FileDescription:  .NET Framework
Product:          Microsoft® .NET Framework
ProductVersion:   2.0.50727.1433
Debug:            False
Patched:          False
PreRelease:       False
PrivateBuild:     False
SpecialBuild:     False
Language:         English (United States)

Assembly Name=System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Assembly CLR Version=v2.0.50727
Assembly Version=2.0.0.0
Assembly Location=C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll
Assembly File Version:
File:             C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll
InternalName:     System.Xml.dll
OriginalFilename: System.Xml.dll
FileVersion:      2.0.50727.1433 (REDBITS.050727-1400)
FileDescription:  .NET Framework
Product:          Microsoft® .NET Framework
ProductVersion:   2.0.50727.1433
Debug:            False
Patched:          False
PreRelease:       False
PrivateBuild:     False
SpecialBuild:     False
Language:         English (United States)

Assembly Name=System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Assembly CLR Version=v2.0.50727
Assembly Version=2.0.0.0
Assembly Location=C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll
Assembly File Version:
File:             C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll
InternalName:     System.Configuration.dll
OriginalFilename: System.Configuration.dll
FileVersion:      2.0.50727.1433 (REDBITS.050727-1400)
FileDescription:  System.Configuration.dll
Product:          Microsoft® .NET Framework
ProductVersion:   2.0.50727.1433
Debug:            False
Patched:          False
PreRelease:       False
PrivateBuild:     False
SpecialBuild:     False
Language:         English (United States)

Assembly Name=System.Web.RegularExpressions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Assembly CLR Version=v2.0.50727
Assembly Version=2.0.0.0
Assembly Location=C:\WINDOWS\assembly\GAC_MSIL\System.Web.RegularExpressions\2.0.0.0__b03f5f7f11d50a3a\System.Web.RegularExpressions.dll
Assembly File Version:
File:             C:\WINDOWS\assembly\GAC_MSIL\System.Web.RegularExpressions\2.0.0.0__b03f5f7f11d50a3a\System.Web.RegularExpressions.dll
InternalName:     System.Web.RegularExpressions.dll
OriginalFilename: System.Web.RegularExpressions.dll
FileVersion:      2.0.50727.1433 (REDBITS.050727-1400)
FileDescription:  System.Web.RegularExpressions.dll
Product:          Microsoft® .NET Framework
ProductVersion:   2.0.50727.1433
Debug:            False
Patched:          False
PreRelease:       False
PrivateBuild:     False
SpecialBuild:     False
Language:         English (United States)

Assembly Name=Microsoft.JScript, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Assembly CLR Version=v2.0.50727
Assembly Version=8.0.0.0
Assembly Location=C:\WINDOWS\assembly\GAC_MSIL\Microsoft.JScript\8.0.0.0__b03f5f7f11d50a3a\Microsoft.JScript.dll
Assembly File Version:
File:             C:\WINDOWS\assembly\GAC_MSIL\Microsoft.JScript\8.0.0.0__b03f5f7f11d50a3a\Microsoft.JScript.dll
InternalName:     Microsoft.JScript.dll
OriginalFilename: Microsoft.JScript.dll
FileVersion:      8.0.50727.1433
FileDescription:  Microsoft.JScript.dll
Product:          Microsoft (R) Visual Studio (R) 2005
ProductVersion:   8.0.50727.1433
Debug:            False
Patched:          False
PreRelease:       False
PrivateBuild:     False
SpecialBuild:     False
Language:         Language Neutral

Assembly Name=CppCodeProvider, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Assembly CLR Version=v2.0.50727
Assembly Version=8.0.0.0
Assembly Location=C:\WINDOWS\assembly\GAC_MSIL\CppCodeProvider\8.0.0.0__b03f5f7f11d50a3a\CppCodeProvider.dll
Assembly File Version:
File:             C:\WINDOWS\assembly\GAC_MSIL\CppCodeProvider\8.0.0.0__b03f5f7f11d50a3a\CppCodeProvider.dll
InternalName:     CppCodeProvider.dll
OriginalFilename: CppCodeProvider.dll
FileVersion:      8.0.50727.813
FileDescription:  CppCodeProvider.dll
Product:          Microsoft (R) Visual Studio (R) 2005
ProductVersion:   8.0.50727.813
Debug:            False
Patched:          False
PreRelease:       False
PrivateBuild:     False
SpecialBuild:     False
Language:         Language Neutral

Assembly Name=App_global.asax.3iyvjmrk, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null
Assembly CLR Version=v2.0.50727
Assembly Version=0.0.0.0
Assembly Location=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\services\a8a490c5\21badae0\App_global.asax.3iyvjmrk.dll
Assembly File Version:
File:             C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\services\a8a490c5\21badae0\App_global.asax.3iyvjmrk.dll
InternalName:     App_global.asax.3iyvjmrk.dll
OriginalFilename: App_global.asax.3iyvjmrk.dll
FileVersion:      0.0.0.0
FileDescription:  
Product:         
ProductVersion:   0.0.0.0
Debug:            False
Patched:          False
PreRelease:       False
PrivateBuild:     False
SpecialBuild:     False
Language:         Language Neutral

Assembly Name=Microsoft.TeamFoundation.Server, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Assembly CLR Version=v2.0.50727
Assembly Version=9.0.0.0
Assembly Location=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\services\a8a490c5\21badae0\assembly\dl3\c371c214\00f59c0d_7422c801\Microsoft.TeamFoundation.Server.DLL
Assembly File Version:
File:             C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\services\a8a490c5\21badae0\assembly\dl3\c371c214\00f59c0d_7422c801\Microsoft.TeamFoundation.Server.DLL
InternalName:     Microsoft.TeamFoundation.Server.dll
OriginalFilename: Microsoft.TeamFoundation.Server.dll
FileVersion:      9.0.21022.8
FileDescription:  Microsoft.TeamFoundation.Server.dll
Product:          Microsoft (R) Visual Studio (R) 2008
ProductVersion:   9.0.21022.8
Debug:            False
Patched:          False
PreRelease:       False
PrivateBuild:     False
SpecialBuild:     False
Language:         Language Neutral

Assembly Name=Microsoft.TeamFoundation.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Assembly CLR Version=v2.0.50727
Assembly Version=9.0.0.0
Assembly Location=C:\WINDOWS\assembly\GAC_32\Microsoft.TeamFoundation.Common\9.0.0.0__b03f5f7f11d50a3a\Microsoft.TeamFoundation.Common.dll
Assembly File Version:
File:             C:\WINDOWS\assembly\GAC_32\Microsoft.TeamFoundation.Common\9.0.0.0__b03f5f7f11d50a3a\Microsoft.TeamFoundation.Common.dll
InternalName:     Microsoft.TeamFoundation.Common.dll
OriginalFilename: Microsoft.TeamFoundation.Common.dll
FileVersion:      9.0.21022.8
FileDescription:  Microsoft.TeamFoundation.Common.dll
Product:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

如果您检查上述详细信息，那么您将看到以下内容:

Exception: SqlException
    Message: Cannot open database "TfsIntegration" requested by the login. The login failed.
    Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.

数据库服务器已获取用户。那么为什么？

我试图从添加/删除修复它并收到以下错误:

---------------------------
Microsoft Visual Studio 2008 Team Foundation Server Setup
---------------------------
Error 29002.The Team Foundation databases could not be repaired. For more information, see the Microsoft Windows Installer (MSI) log.
---------------------------
Retry   Cancel  
---------------------------

**I checked the event viewer it has:**

Event Type:    Error
Event Source:    MsiInstaller
Event Category:    None
Event ID:    10005
Date:        2/2/2010
Time:        10:21:57 AM
User:        UGSERVER\Administrator
Computer:    UGSERVER
Description:
Product: Microsoft Visual Studio 2008 Team Foundation Server - ENU -- Error 29002.The Team Foundation databases could not be repaired. For more information, see the Microsoft Windows Installer (MSI) log.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 33 35 45 44 37 38 38   {35ED788
0008: 42 2d 44 41 36 42 2d 33   B-DA6B-3
0010: 33 37 33 2d 42 42 32 42   373-BB2B
0018: 2d 41 36 38 43 31 34 39   -A68C149
0020: 45 41 38 31 41 7d         EA81A} 

Answer 1

Exception: SqlException
Message: Cannot open database "TfsIntegration" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
这听起来像是问题的根源。检查您的网络上没有任何变化，并且没有人干预数据库权限。还要检查是否仍然启用了 Windows 身份验证(不是 SQL Server)。