So I've been installing the Single Server Versions of Team Fondation Server in Virtual PC quite regularly throughout the life cycle of the product and now that we have final bits for the .NET Framework I am excited that we can now create a pretty stable base and only install incremental TFS builds to test.
In my latest VM I've been getting this error on startup:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7009
Time: 11:54:40 AM
Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Well SQL Server Reporting Services is needed for all the reporting aspects of TFS and also when creating new projects so it needs to run and I don't want to have to go and start it manually each time I reboot my server. The Single Server is starting a lot of stuff including a DC so it may be that there are just too many things to start and RS is timing out. That didn't use to happen before so I did a bit of digging and well I didn't find much on this particular error until I stumbled on this article http://support.microsoft.com/?kbid=884495 which is completely unrelated (since it talks about ISA) but the error is the same so I applied the steps to resolve this problem on my VM and all is good now. I used a timeout of 60000 I may take less but that's the one I used.
Hope this help someone else,
”It's all good!”