title: TFS 2010 abort servicing activity
body: <p>At the start of the year I pushed to setting up TFS for a more structured approach to things (before, everyone would change things as they went, obviously A Bad Thing). I set up a very basic single server TFS 2010 installation. The TFS databases resided on one of our Dev servers (SQL 2008).</p>
  
  <p>Everything went well until:
  We uninstalled SQL 2008, installed SQL 2008 R2 and reattached the databases. Since then TFS has been impossible:</p>
  
  <ul>
  <li>The clients (SQL Mgt Studio and VS2008/2010) could no longer connect (error 404 not found)</li>
  <li><a href="http://localhost:8080/tfs/" rel="nofollow">http://localhost:8080/tfs/</a> gave:<br>
  "Team Foundation services are not available from the server.
  Technical information (for administrator):
  The request could not be processed because the application is not configured correctly. No service host is available for the request."</li>
  <li>Team Foundation Admin Console finds the collections, everything SEEMS ok.</li>
  </ul>
  
  <p>In an effort to jumpstart things:</p>
  
  <ul>
  <li>I restarted the website and it's application pool</li>
  <li>I rebooted the server</li>
  </ul>
  
  <p>No effect.</p>
  
  <p>Then I stopped the collection (that worked) to re-enter the database information, save it and start the collection again. However, it kept hanging on the save. I tried to detach the collection, but that didn't do anything. So now I have a stopped collection with the following activities:</p>
  
  <ul>
  <li>Prepare Collection (Success)</li>
  <li>Create Collection (Success)</li>
  <li>Servicing Collection (Queued)</li>
  <li>Detach Collection (Queued) (3 times, since I tried this a couple of time)</li>
  </ul>
  
  <p>and nothing is budging.</p>
  
  <p>I have all source in my local folder, so in extremis I can delete and uninstall the whole thing and start over, but... I rather not.</p>
  
  <p>Any way to unblock this?</p>