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

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!” 

Comments

# re: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server Install of TFS B3R
Gravatar Thanks!!! It helped a lot!
Left by vlad on 8/7/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
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 1/3/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
Gravatar Excellent glad to hear it.
Left by ET on 1/3/2007 8:07 PM
# re: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server
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 3/2/2008 10:59 AM
# re: Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect on Single Server
Gravatar Great!!!! Thanks a lot. i used this to solve an issue on sql server agent. Thank you!!!
Left by Mario on 5/11/2009 9:09 AM

Leave Your Comment

Title*
Name*
Email (never displayed)
 (will show your gravatar)
Url
Comment*

Preview Your Comment.