Etienne's VSTS World

Fascinating tidbits about VSTS and .NET (well I hope...)

  Home  |   Contact  |   Syndication    |   Login
  148 Posts | 0 Stories | 83 Comments | 122 Trackbacks

News



View Étienne Tremblay's profile on LinkedIn

Tag Cloud


Archives

Post Categories

Image Galleries

My Friends

My Links

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
Date:  11/3/2005
Time:  11:54:40 AM
User:  N/A
Computer: EDS-KFBOJV3ZTG5
Description:
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,

Cheers,

ET

”It's all good!” 

posted on Thursday, November 03, 2005 4:44 AM

Feedback

# re: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server Install of TFS B3R 8/7/2006 12:46 PM vlad
Thanks!!! It helped a lot!

# re: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server Install of TFS B3R 1/3/2007 7:48 PM Gerald Lim
I used the same method to resolve my timeout issue on "SQL Server Integration Service" on SQL server 2005. Thank you very much :)

# re: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server Install of TFS B3R 1/3/2007 8:07 PM ET
Excellent glad to hear it.

# re: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server 3/2/2008 10:59 AM Attila Nagy
Woohho! This was the only resource that was of help! :) I struggled with an msde 2005 sql server timing out, now it seems that the above linked MS article has solved the problem!
Many thanks for letting us know it! (I think I would have never found that on my own...)

Post Feedback

Title:
Name:
Email: (never displayed)
Url:
Comments: 
Please add 5 and 7 and type the answer here: