Jand writes about team development and Microsoft.NET

This is my second post about errors which can occur while installing Team Foundation Server.

If you find errors like this in your event log:

Source:	MSSQLSERVER
Event ID:	18456
Description:	Login failed for user ‘NT AUTHORITY\SYSTEM’. [CLIENT: <local machine>]

Source:	Report Server Windows
Event ID:	107
Description:	Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

and/or for example the TFSSchedulerService does not start after reboot, your SQL services might start to slow. This happens mostly if you install TFS in Single-Server mode.
Other services trying to connect to databases in the SQL Server but this is not completely up and running. To avoid this problem you need to delay loading this specific services.

Go to the registry editor and add a Multi-String Value to the corresponding service entry:

Key: \HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ReportServer
Right click “New Multi-String Value”
Name: DependOnService
Value: MSSQLSERVER

Do this for all services like ReportServer and TFSSchedulerService. There is also a Knowledge-Base article here.