Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1572

Re: Increase Service Startup Timeout Value?

Show all headers | View raw

On Feb 1, 4:42 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Joe Cool (joecool1...@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.
>

That key does not exist in my computer. Does that mean 30000 ms is the
default and in order to override that I need to create one with the
overriding value I want to specify?

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Re: Increase Service Startup Timeout Value? Joe Cool <joecool1969@live.com> - 2011-02-01 14:20 -0800
  Re: Increase Service Startup Timeout Value? Joe Cool <joecool1969@live.com> - 2011-02-01 15:33 -0800

csiph-web