Hi,
We are using sql 2005 instance with SP2.Sometimes users were are not
able to connect to instance and it gets solved only after instance is
recycled.We get the below given error in sql error log.

Version : Microsoft SQL Server 2005 - 9.00.3152.00

Error: 17189, Severity: 16, State: 1.

SQL Server failed with error code 0xc0000000 to spawn a thread to
process a
new login or connection. Check the SQL Server error log and the
Windows
event logs for information about possible related problems.

Has any one faced this issue...
--
Thanks
Vijayasekar

vijay wrote:
> Hi,
Hello


If it's windows 2003 sp1 you can try add the following registry key and
reboot the server.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters\SynAttackProtec{DWORD}=
0
But it can couse problem if somebody wants to use SYN attack so you need
to test first and understand risk .

regards
SW

> We are using sql 2005 instance with SP2.Sometimes users were are not
> able to connect to instance and it gets solved only after instance is
> recycled.We get the below given error in sql error log.
>
> Version : Microsoft SQL Server 2005 - 9.00.3152.00
>
> Error: 17189, Severity: 16, State: 1.
>
> SQL Server failed with error code 0xc0000000 to spawn a thread to
> process a
> new login or connection. Check the SQL Server error log and the
> Windows
> event logs for information about possible related problems.
>
> Has any one faced this issue...
> --
> Thanks
> Vijayasekar
>