locked
Can't connect to TFS server RRS feed

  • Question

  • Hi all,

    I'm trying to setup Team Server for use, but when I try to connect via Visual Studio, I am getting several errors.
    I have installed SQL Server 2012 separately and am using this as the SQL Server for TFS. I probably screwed up something when configuring it, however.

    Anyway, when connecting, I get these errors:

    Login failed for user 'DOMAIN\SERVER$'. Reason: Could not find a login matching the name provided. [CLIENT: 192.168.0.2]

    TF53010: The following error has occurred in a Team Foundation component or extension:
    Date (UTC): 2012-04-14 10:30:59
    Machine: SERVER
    Application Domain: /LM/W3SVC/8080/ROOT/tfs-1-129788729239013125
    Assembly: Microsoft.TeamFoundation.Framework.Server, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
    Service Host:
    Process Details:
      Process Name: w3wp
      Process Id: 3472
      Thread Id: 5596
      Account name: NT AUTHORITY\NETWORK SERVICE

    Detailed Message: Application Request Processing Started

    Server Version = Microsoft.TeamFoundation.Framework.Server, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
    Service Account = NT AUTHORITY\NETWORK SERVICE
    Machine Name = SERVER


    Exception Message: TF246017: Team Foundation Server could not connect to the database. Verify that the server that is hosting the database is operational, and that network problems are not blocking communication with the server. (type DatabaseConnectionException)

    Exception Stack Trace:    at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(Int32 errorNumber, SqlException sqlException, SqlError sqlError)
       at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(SqlException sqlException)
       at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)
       at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException(SqlException ex)
       at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
       at Microsoft.TeamFoundation.Framework.Server.ExtendedAttributeComponent.ReadDatabaseAttribute(String attributeName)
       at Microsoft.TeamFoundation.Framework.Server.DatabaseConnectionValidator.ValidateDatabaseInstanceStamp(String configConnectionString, Guid configInstanceId)
       at 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)
       at Microsoft.TeamFoundation.Framework.Server.ApplicationServiceHost..ctor(Guid instanceId, String connectionString, String physicalDirectory, String plugInDirectory, String virtualDirectory, Boolean failOnInvalidConfiguration)
       at Microsoft.TeamFoundation.Framework.Server.TeamFoundationApplication.AttemptStart()

    Inner Exception Details:

    Exception Message: Login failed for user 'DOMAIN\SERVER$'. (type SqlException)
    SQL Exception Class: 14
    SQL Exception Number: 18456
    SQL Exception Procedure:
    SQL Exception Line Number: 65536
    SQL Exception Server: tcp:localhost,49172
    SQL Exception State: 1
    SQL Error(s):

    Exception Data Dictionary:
    HelpLink.ProdName = Microsoft SQL Server
    HelpLink.EvtSrc = MSSQLServer
    HelpLink.EvtID = 18456
    HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
    HelpLink.LinkId = 20476


    Exception Stack Trace:    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.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)


    Web Request Details
        Url: https://<url>:8082/tfs/Services/v1.0/Registration.asmx [method: POST]
        User Agent: Team Foundation (devenv.exe, 10.0.40219.1)
        Headers: Content-Length=390&Content-Type=text%2fxml%3b+charset%3dutf-8&Accept-Encoding=gzip%2cgzip%2cgzip&Accept-Language=sv-SE&Authorization=NTLM+TlRMTVNTUAADAAAAGAAYAIYAAABSAVIBngAAABAAEABYAAAAGgAaAGgAAAAEAAQAggAAAAAAAADwAQAABYKIogYBsR0AAAAPLu0EbFAvhzAl0d3tIU85YlQAVwBJAEwASQBHAEgAVABBAGQAbQBpAG4AaQBzAHQAcgBhAHQAbwByAFAAQwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAC2%2fS%2fYx6WrRDq%2bxZC%2foMFFAQEAAAAAAABQLsOtKRrNAVeCcXjjqZoaAAAAAAIAEABUAFcASQBMAEkARwBIAFQAAQAMAFMARQBSAFYARQBSAAQAGABUAHcAaQBsAGkAZwBoAHQALgBuAGUAdAADACYAUwBlAHIAdgBlAHIALgBUAHcAaQBsAGkAZwBoAHQALgBuAGUAdAAFABgAVAB3AGkAbABpAGcAaAB0AC4AbgBlAHQABwAIAFAuw60pGs0BBgAEAAIAAAAIADAAMAAAAAAAAAAAAAAAADAAAAUKwb%2bLQue4F9sjd3WcS2rbxJnJy566beLUrLrCDQcQCgAQAAZzkcfNPMakBV%2bSHEfmLD4JADQASABUAFQAUAAvAGUAcwBzAGUAbgB0AGkAYQAuAG0AYQBnAGkAYwBiAGkAdAAuAG4AZQB0AAAAAAAAAAAAAAAAAA%3d%3d&Expect=100-continue&Host=essentia.magicbit.net%3a8082&User-Agent=Team+Foundation+(devenv.exe%2c+10.0.40219.1)&X-TFS-Version=1.0.0.0&X-TFS-Session=0b021ba1-341d-4afe-be37-a9f24de35547&SOAPAction=%22http%3a%2f%2fschemas.microsoft.com%2fTeamFoundation%2f2005%2f06%2fServices%2fRegistration%2f03%2fGetRegistrationEntries%22
        Path: /tfs/Services/v1.0/Registration.asmx
        Local Request: False
        Host Address: 213.89.137.165
        User: DOMAIN\Administrator [authentication type: NTLM]

    Keep in mind that I just started installing this and configured it just recently for the first time, so I am not well versed in security practices using it, nor do I know how to fix them.

    Obviously I'd also like to create a different set of credentials that I can use to connect to the TFS server than the domain admin, but I don't know how to configure that.
    (Also, this is not a business server, so security is not adamant.)

    Any help would be appreciated.

    If it helps, it seems there is an entry in the SQL server for the computer:

    name    principal_id    sid    type    type_desc    is_disabled    create_date    modify_date    default_database_name    default_language_name    credential_id    owning_principal_id    is_fixed_role
    DOMAIN\SERVER$    268    <snip>    U    WINDOWS_LOGIN    0    2012-04-14 11:41:51.757    2012-04-14 11:41:51.763    master    us_english    NULL    NULL    0

    Log says DOMAIN\SERVER$ does not exist? (State: 5)

    Maybe I should ask on the SQL Board? I assume this is related to some SQL Problem?

    Saturday, April 14, 2012 10:51 AM

Answers

  • Hi Natsuki,

    Thank you for your post.

    I suppose you are install TFS 2010, and want to integrate it with SQl server 2012. There is no official document in MSDN or TFS documentation to ensure that TFS 2010 is compatible with the SQL Server 2012. So, please install the support components list in TFS 2010 installation guide.

    Thanks,


    Lily Wu [MSFT]
    MSDN Community Support | Feedback to us

    Monday, April 16, 2012 3:51 AM
    Moderator

All replies

  • Exception Message: TF246017: Team Foundation Server could not connect to the database. Verify that the server that is hosting the database is operational, an

    TFS 2010 does not support SQL 2012

    How did you upgrade from TFS databases from SQL 2010 to SQL 2012 ?

    Saturday, April 14, 2012 4:27 PM
  • No, I installed SQL 2012 first, then Team Foundation Server. It is a fresh install.
    Saturday, April 14, 2012 4:30 PM
  • No, I installed SQL 2012 first, then Team Foundation Server. It is a fresh install.

    and had you configured TFS especially data tier ?

    see this thread for TFS 2010 and SQL 2012: Upgrade TFS 2010 SP1 with SQL Server 2008 to SQL Server 2012

    Saturday, April 14, 2012 4:31 PM
  • I did run the config wizard, which I managed to get connected to the sql server.
    I did run into some issue with it being unable to create the default collection, however.

    I don't know what you mean by data tier, though.

    Saturday, April 14, 2012 4:33 PM

  • I did run into some issue with it being unable to create the default collection, however.

    so you haven't created the necessary database & tables in SQL 2012.

    Data Tier:

    the backbone of TFS where it stores its data. This is a SQL Server either on the same instance (single server installation) or a SQL Server on any other server

    Saturday, April 14, 2012 4:38 PM
  • ----
    so you haven't created the necessary database & tables in SQL 2012.
    ----
    If that's what it means, then most likely, yes. I have been unable to fix that problem.
    (I might assume that the problem mentioned in the first post might have something to do with it being unable to create collection.)

    The question is if it works on SQL 2012. I'd rather not install SQL 2008 due to various problems. If possible, I'd like to explore other options first.
    If it comes to worst, I may have to do it tomorrow or the day after (install SQL 2008).

    Saturday, April 14, 2012 4:42 PM
  • ----
    so you haven't created the necessary database & tables in SQL 2012.
    ----
    If that's what it means, then most likely, yes. I have been unable to fix that problem.
    (I might assume that the problem mentioned in the first post might have something to do with it being unable to create collection.)

    The question is if it works on SQL 2012. I'd rather not install SQL 2008 due to various problems. If possible, I'd like to explore other options first.
    If it comes to worst, I may have to do it tomorrow or the day after (install SQL 2008).

    don't use SQL 2008.

    Instead use SQL 2008R2 if you can't use SQL 2012

    Saturday, April 14, 2012 4:57 PM
  • Hi Natsuki,

    I am moving your thread into the Team Foundation Server - General Forum for dedicated support. Thanks for your understanding.

    Best Regards,


    Jack Zhai [MSFT]
    MSDN Community Support | Feedback to us

    Monday, April 16, 2012 2:47 AM
  • Hi Natsuki,

    Thank you for your post.

    I suppose you are install TFS 2010, and want to integrate it with SQl server 2012. There is no official document in MSDN or TFS documentation to ensure that TFS 2010 is compatible with the SQL Server 2012. So, please install the support components list in TFS 2010 installation guide.

    Thanks,


    Lily Wu [MSFT]
    MSDN Community Support | Feedback to us

    Monday, April 16, 2012 3:51 AM
    Moderator
  • I am not sure if this will work, but try setting the compatibility mode for the TFS databases to SQL 2008.  (Properties > Options)
    Friday, April 20, 2012 12:04 AM