Category Archives: sql server 2008

TFS 2008 and SQL Server 2008 on one machine

Some days ago, I installed Team Foundation Server 2008 on one box with SQL Server 2008. Everything seemed to function well, but since the installation of TFS 2008 ‘at least one service did not start up’.

Digging into the event viewer, I discovered TFS Scheduler did not function well. It did not start up because it could not find the TFSIntegration database. The reason? It starts up in racing condition with MS SQL Server. To solve the problem, I added a dependency for the TFS Scheduler service on MSSQLSERVER. Problem solved!

The link on how to perform this task: http://support.microsoft.com/kb/193888. If you need more information, send me a message ;)