title: Removing "dead" user accounts from TFS & SQL after server migration
body: <p>I have searched high and low for a solution to this problem to no avail.</p>
  
  <p>Basically, the situation is as follows:</p>
  
  <p>We are currently migrating our existing TFS server to another machine, which has been going well up until now.
  Unfortunately i'm unable to complete the configuration of Report server and the likes as I get the following error:</p>
  
  <p><strong>"Failed to add SWSERVER\susan account to the TFSEXECROLE role on the Tfs_Warehouse relational database"</strong></p>
  
  <p>SWSERVER is the name of the previous machine that hosted the TFS server.</p>
  
  <p>The thing is that SWSERVER\susan is an absolete account, and was actually removed as a user account on the previous machine, which I think is a major part of the problem.</p>
  
  <p>From what I can gather is that TFS can still see it in the restored databases and thinks it's a viable account but seeing as the account technically doesn't exist it can't actually do anything with it. </p>
  
  <p>Another part of the question is that if I go to the original (SWSERVER) and remove the SWSERVER\susan user, will that have an effect on how TFS or SQL operate especially if that account (or any other similar account) are linked to anything in either program?</p>
  
  <p>I'd much appreciate any help anyone can provide.
  I've hope i've explained my situation well enough but if anybody needs any more information, please don't hesitate to let me know.</p>