16740

TF246017: team foundation server could not connect to the database

<h3>Question</h3>

I am facing a problem with logging into TFS. I get the following error:

<blockquote>

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 SoapException)SoapException Details:

</blockquote>
<h3>Answer1:</h3>

Please check below thing to narrow down the issue:

<ul><li>Make sure you are the member of the Administration Console Users. Otherwise you cannot access the Admin Console.</li> <li>Make sure the SQL Server is stated and available, and the network connectivity is OK.</li> <li>Check the Service Account, make sure the Service Account has been added in SQL Server.</li> </ul>

You can also refer to the solution in below link to fix the issue: https://www.ganshani.com/alm/tfs/visual%20studio/solved-tf246017-team-foundation-server-could-not-connect-to-the-database/

If above solution can not resolve the problem, please check the Event log. The Windows Event Log is a good candidate where to look for the potential cause.


<h3>Answer2:</h3>

I know this is old, but here was my situation: We have 11 collections on our instance, 2 were failing with this error, showing me it wasn't an access / connection issue. Checking Event Viewer (as @Andy Li-MSFT suggests) showed it was A timeout occurred while waiting for memory resources to execute the query in resource pool 'default' (2). Rerun the query.

Checking task manager showed the culprit - elastic search was using well over 2GB of memory. I killed the service, the collections applied the patch quickly without issue.

Looks like I need to ask our server admins to give us a bit more memory....


<h3>Answer3:</h3>

Hi the below steps worked for me.

Select Application Tier in the TFS Administration Console.

In the Application Tier Summary which contains the Service Account details.

Click Reapply Account.

来源:https://stackoverflow.com/questions/45129042/tf246017-team-foundation-server-could-not-connect-to-the-database

Recommend

  • EF: one-to-one relationship
  • Enabling/Disabling row in a datagrid(MVVM pattern)
  • Get Network Interface Names and Set All to DHCP Batch Script
  • JSF datatable hide column border if column is not displayed(rendered)
  • XCUITest: Running tests across two apps in a coordinated fashion
  • Failure to Read Updated AnyLogic DB Values
  • Upload video and extract thumbnail using Amazon s3
  • 1and1 htaccess file not working
  • JS showModalDialog not working in chrome as modal
  • magento 2 rest api : get cart items with images
  • Limit # of records returned based on a form control
  • Using PHP & Tornado
  • Limit number of button clicks
  • Specify the _id field using Bulk.IndexMany in ElasticSearch
  • API Gateway Encoding multipart/form-data
  • configure openjpa on to spring boot
  • Laravel 5.7: Custom blade template for Maintenance Mode but not 503.blade.php
  • Making query to find nearest multiple(Lat,Long) from the single(Lat,Long)
  • async GET request with body from browser
  • Battery life if using GPS and background app ios/android
  • How to sort by Lucene.Net field and ignore common stop words such as 'a' and 'the
  • Why am I getting an Argument exception when creating event handler dynamically?
  • How to get a time and Date Separately?
  • ASP.NET GridView throws: The version of SQL Server in use does not support datatype 'date'
  • Get name of days between two date in ios?
  • How to display content depending on dropdown menue user selection
  • How to add html image in to velocity template file to send email?
  • Does hibernate load two seprate copies of same instance if they are loaded twice from database?
  • How to use array in autohotkey?
  • Generate and export point cloud from Project Tango
  • Tensorflow Dataset API restore Iterator after completing one epoch
  • Ruby regex for matching simpliest Ruby's regexes
  • DataTables move rows between tables
  • How to turn off notice reporting in xampp?
  • How to integrate angular2-material (alpha 8.2) with angular2-Quickstart app
  • read part of h5 dataset python
  • Jersey serializes character value to ASCII equivalent numeric string
  • convert json to excel in java