event id 17189

• varun_3g

  Mr or Mrs. 500

  Points: 587

  More actions

  February 3, 2009 at 5:44 pm

  #128446

  Whenever theres deadlock on my SQL Box I see below error in event viewer too and searching about it I couldnt found out much other then the following information but I dont want to set the registry settings without being sure, I think it has to do with memeory, any thoughts highly apprecited.

  Thanks, varun

  Event ID: 17189

  Source MSSQLSERVER

  Type Error

  Description SQL Server failed with error code to spawn a thread to process a new login or connection. i

  Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT: named pipe]

  Add the following registry key and reboot the server: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\SynAttackProtect{DWORD} = 0

  Security Note:

  Setting this registry key may expose the server to a SYN flood denial-of-service attack. Add this registry value only if necessary and with an understanding of the security risks