Can't connect to TFS server

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?

Answer 1

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 ?

Answer 2

No, I installed SQL 2012 first, then Team Foundation Server. It is a fresh install.

Answer 3

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

Answer 4

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.

Answer 5

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

Answer 6

----
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).

Answer 7

----
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

Answer 8

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

Answer 9

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

Answer 10

I am not sure if this will work, but try setting the compatibility mode for the TFS databases to SQL 2008.  (Properties > Options)