Geeks With Blogs

News

View Étienne Tremblay's profile on LinkedIn
ET's VS and TFS World Fascinating tidbits about VS and TFS and .NET (well I hope...)

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 3, 2005 4:44 AM Visual Studio Team System | Back to top


Comments on this post: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server Install of TFS B3R

# re: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server Install of TFS B3R
Requesting Gravatar...
Thanks!!! It helped a lot!
Left by vlad on Aug 07, 2006 12:46 PM

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

# re: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server Install of TFS B3R
Requesting Gravatar...
Excellent glad to hear it.
Left by ET on Jan 03, 2007 8:07 PM

# re: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server
Requesting Gravatar...
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...)
Left by Attila Nagy on Mar 02, 2008 10:59 AM

# re: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server
Requesting Gravatar...
Great!!!! Thanks a lot. i used this to solve an issue on sql server agent. Thank you!!!
Left by Mario on May 11, 2009 9:09 AM

Your comment:
 (will show your gravatar)


Copyright © Etienne Tremblay | Powered by: GeeksWithBlogs.net