MSSQLSERVER Service Failed To Start, TDSSNIClient initialization failed with error 0x34, SQL Server could not spawn FRunCM thread

Problem

The MSSQLSERVER service failed to start when you update Microsoft SQL Server Service Pack 1 or 2. You will receive the following error messages in the event logs:

	Event Type:	Error
	Event Source:	MSSQLSERVER
	Event Category:	(2)
	Event ID:	17182
	Description:
	TDSSNIClient initialization failed with error 0x34, status code 0x1e.


	Event Type:	Error
	Event Source:	MSSQLSERVER
	Event Category:	(2)
	Event ID:	17182
	Description:
	TDSSNIClient initialization failed with error 0x34, status code 0x1.


	Event Type:	Error
	Event Source:	MSSQLSERVER
	Event Category:	(2)
	Event ID:	17826
	Description:
	Could not start the network library because of an internal error in the network library. 


	Event Type:	Error
	Event Source:	MSSQLSERVER
	Event Category:	(2)
	Event ID:	17120
	Description:
	SQL Server could not spawn FRunCM thread.
	

Solution

  1. Login as Administrator.
  2. Click Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager
  3. Click SQL Server 2005 Network Configuration > Protocols for MSSQLSERVER
  4. Double click TCP/IP in the right side.
  5. Change Listen All to Yes in the popup window.
  6. Click Ok button
  7. Start your MSSQLSERVER service:
MSSQLSERVER Service Failed To Start

Add Feedback