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 get 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. Go to "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

Related Resources

• Error Messages of SQL Server 2005 Start Up Failure
• SQL Server could not spawn FRunCM thread.