Path: csiph.com!eeepc.pasdenom.info!news.pasdenom.info!news.dougwise.org!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: Increase Service Startup Timeout Value? Date: Tue, 01 Feb 2011 22:42:02 +0100 Organization: Erland Sommarskog Lines: 30 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx02.eternal-september.org; posting-host="L7AjRjCtBsuTlmPDWTM+Pw"; logging-data="8511"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/NOhjX6YIVLPnTNnOE4q6c" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:o9y9bJYr3VpPNMYE76YB+TqnkM8= Xref: csiph.com comp.databases.ms-sqlserver:1588 Joe Cool (joecool1969@live.com) writes: > I do all of my development work in a 64bit Windows 7 Virtual Machine > using VMWare. In order to test software in multiple versions of SQL > Server I have four instances running in it, a SQl Express and SQL > Server instance for both 2005 and 2008. > > Mmost of the time one or more instances will fail to start at boot > time. The event log indicates that it failed to start in the alloted > time, 30000 milliseconds. > > I looked through all of the instances properties but could not find > anywhere that I could boost that value up any. I tried checking the > boost priority checkbox on the processor page but that didn't help. This timeout is not SQL Server-specifc, but a general Windows parameter. You can control it through the registy. The key name is HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SerivcesPipeTimeout. It should be a DWORD, and the value is in milliseconds. Beware that the name has "Services" in plural. I had it spelt in singular on my machine, and it was driving me crazy why it did not work, when it worked on another machine. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx