TFS is wonky after server move
After spending a couple days on the phone with MS Product Support on this we finally have it working.
- Reinstall TFS on the App Server
- Go through IIS and found app pools were not set right, changed back to f/x 2.0 classic
- Database machine's firewall was not allowing TCP connections on the correct port to SQL Server (hence the not connecting first time, then it went to named pipes and connected - but TFS wants TCP connections)
These were the main culprits. We even went through all the security accounts and those ended up having the right permissions so were more of a red herring to chase.
There is a tool for moving TFS - use it! ;)