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: