TFS 2008 / Visual Studio Team Foundation Server Task Scheduler not starting automatically
Issue
When we restart the Team Foundation Server(The AT box, on a dual tier server), Visual Studio Team Foundation Server Task Scheduler service might not start automatically even if it is set to start automatically
Resolution
To resolve this issue make the SQL Server Agent a dependency to Visual Studio Team Foundation Server Task Scheduler Service.
To do this, go to the registry editor and add a Multi-String Value to the corresponding service entry:
Start | Run | Regedit
Key: \HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TFSServerScheduler
Right click "New Multi-String Value"
Name: DependOnService
Value: SQLAgent (you will have to mentioned SQL Server Name/Instance Name)
Content by: Romitg
Reviewed by: Lucky