I got tired of all the boot time errors when booting TFS in a single server deployment:
TF050801 - Initialization did not complete because there was no task list registered with the TFS Registration service.
ASP.NET 1309 - Cannot open database TfsIntegration - login failed
TF30065 - Unhandled exception occurred - cannot open databse TfsIntegration.
MSSQLSERVER event 18456 - login failed for .\TFSService

I figured they were related to the fact that there is no dependency on SQL Server and TFS is trying to login before SQL Server is really up.

So I put a dependency on TFSServerScheduler of MSSQLSERVER and got a clean boot:
Need sc.exe (built in to Windows 2003 Server, available on resource kit for other machines.

At command prompt:
sc.exe config TFSServerScheduler depend= MSSQLSERVER
(need space after "=" for depend=).

Trying to move toward sanity....