Break it, fix it

If you ever wondered if it is possible to completely remove an application tier from the TFS Administration Console , here is an answer for you. Yes, but it is tricky and may result in a broken TFS installation. It involves messing with the catalog in the TFS_Configuration database. As a disclaimer, this method is absolutely not supported. Not by me, not by my company, not by Microsoft. Use at your own risks. So if you decide to reproduce the steps I am going to describe, please BACK UP your TFS installation (especially the Tfs_Configuration database). Now, a little bit of context before starting, TFS uses a set of tables known as the catalog to keep track of the different pieces of your installation. It contains a lot of things including the databases, the servers, the web applications, etc. Whenever you had a new piece to the installation (app tier, reporting tier, etc.) it goes into the catalog. Our problem is that for the moment there is no way to tell when you completely

I recently tried to run the TFS BPA using an account containing a dollar ($) sign. It was something like "user$name". I ended up with a rather strange error message looking like the following: Cannot validate the URL provided The scan was generated using the corrected URL "%TFSServerURLValidated%". A quick look at the "Other reports" section of the scan results, I found that the tool was trying to find files in the following directory: c:\Users\ user \AppData\Roaming\Microsoft\TfsBpa\[...] The important part is highlighted. It seems that some of the PowerShell scripts are analyzing the account name as the literal user followed by a variable named $name , instead of interpreting the whole account name as a literal. As I didn't want to go through the various PS scripts in the BPA installation directory, I decided to take the lazy approach. I created a symbolic link C:\Users\user pointing to C:\Users\user$name\ using the following c