• 解决TFS服务器重命名后,无法访问的问题


    公司电脑在进入域之前安装的TFS,进入域后,计算机名称统一修改为工号PC-242,这样的后果是TFS无法访问,打开TFS管理控制台,发现数据库连接串还是用的源计算机名称,如下图

    QQ拼音截图未命名

    找了半天也没找到在哪能修改这个连接串

    功夫不负有心人,终于

    安装目录\Program Files\Microsoft Team Foundation Server 2010\Application Tier\Web Services\

    打开Web.config,修改 key="applicationDatabase" 的Value 为新计算机名称

    image

    重新打开TFS管理控制台,一切OK

    事件错误如下:

    TF53010: Team Foundation 组件或扩展中发生了以下错误:
    日期(UTC): 2013/4/16 7:48:33
    计算机: PC-242
    应用程序域: /LM/W3SVC/8080/ROOT/tfs-1-130105716355752891
    程序集: Microsoft.TeamFoundation.Framework.Server, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
    服务主机: 
    进程详细信息:
      进程名称: w3wp
      进程 ID: 7224
      线程 ID: 4908
      帐户名称: NT AUTHORITY\LOCAL SERVICE
    
    详细消息: 应用程序请求处理已开始
    
    Server Version = Microsoft.TeamFoundation.Framework.Server, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
    Service Account = NT AUTHORITY\LOCAL SERVICE
    Machine Name = PC-242
    
    
    异常消息: TF246017: Team Foundation Server 未能连接到数据库。请验证承载数据库的服务器是否正常运行,且没有网络问题阻止与服务器的通信。 (类型 DatabaseConnectionException)
    
    异常堆栈跟踪:    在 Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(Int32 errorNumber, SqlException sqlException, SqlError sqlError)
       在 Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(SqlException sqlException)
       在 Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)
       在 Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException(SqlException ex)
       在 Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
       在 Microsoft.TeamFoundation.Framework.Server.ExtendedAttributeComponent.ReadDatabaseAttribute(String attributeName)
       在 Microsoft.TeamFoundation.Framework.Server.DatabaseConnectionValidator.ValidateDatabaseInstanceStamp(String configConnectionString, Guid configInstanceId)
       在 Microsoft.TeamFoundation.Framework.Server.DatabaseConnectionValidator.ValidateApplicationConfiguration(String configConnectionString, Guid configInstanceId, List`1 sqlInstances, String analysisInstance, String analysisDatabaseName, Boolean ignoreAnalysisDatasourceUpdateErrors, Boolean autoFixConfiguration, Boolean fullValidation, DatabaseVerificationDatabaseTypes continueOnMissingDatabaseTypes)
       在 Microsoft.TeamFoundation.Framework.Server.ApplicationServiceHost..ctor(Guid instanceId, String connectionString, String physicalDirectory, String plugInDirectory, String virtualDirectory, Boolean failOnInvalidConfiguration)
       在 Microsoft.TeamFoundation.Framework.Server.TeamFoundationApplication.AttemptStart()
    
    内部异常详细信息:
    
    异常消息: 在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: Named Pipes Provider, error: 40 - 无法打开到 SQL Server 的连接) (类型 SqlException)
    SQL 异常类: 20
    SQL 异常编号: 53
    SQL 异常过程: 
    SQL 异常行号: 0
    SQL 异常服务器: 
    SQL 异常状态: 0
    SQL 错误:
    
    异常数据目录:
    HelpLink.ProdName = Microsoft SQL Server
    HelpLink.EvtSrc = MSSQLServer
    HelpLink.EvtID = 53
    HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
    HelpLink.LinkId = 20476
    
    
    异常堆栈跟踪:    在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       在 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
       在 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
       在 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
       在 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       在 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       在 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       在 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
       在 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
       在 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
       在 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       在 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       在 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       在 System.Data.SqlClient.SqlConnection.Open()
       在 Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
    
    
    Web 请求详细信息
        URL: http://pc-242:8080/tfs/Services/v1.0/Registration.asmx [方法: POST]
        用户代理: Team Foundation (devenv.exe, 10.0.40219.1)
        标头: Content-Length=402&Content-Type=text%2fxml%3b+charset%3dutf-8&Accept-Encoding=gzip%2cgzip%2cgzip&Accept-Language=zh-CN&Authorization=NTLM+TlRMTVNTUAADAAAAAAAAAFgAAAAAAAAAWAAAAAAAAABYAAAAAAAAAFgAAAAAAAAAWAAAAAAAAABYAAAABcKIogYBsB0AAAAPqLEjZVq%2bIkf6v3mz4AFefA%3d%3d&Expect=100-continue&Host=pc-242%3a8080&User-Agent=Team+Foundation+(devenv.exe%2c+10.0.40219.1)&X-TFS-Version=1.0.0.0&X-TFS-Session=99fbe203-446b-408f-8ec2-d34badc952a4&SOAPAction=%22http%3a%2f%2fschemas.microsoft.com%2fTeamFoundation%2f2005%2f06%2fServices%2fRegistration%2f03%2fGetRegistrationEntries%22
        路径: /tfs/Services/v1.0/Registration.asmx
        本地请求: True
        主机地址: ::1
        用户: NEUXA\syp242 [身份验证类型: NTLM]
  • 相关阅读:
    git clone代码总是失败
    sublime常用快捷键及插件
    canvas圆形倒计时
    box-show的用法
    全选、反选
    数据库,增删改查
    PHP操作MySQL
    输出六个随机字符串
    约瑟夫环的故事
    Unix编程艺术——摘录一
  • 原文地址:https://www.cnblogs.com/starlet/p/3024332.html
Copyright © 2020-2023  润新知