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