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
MSSQLSERVER Service Failed To Start

Related Resources

Navigator

Other Knowledgebase Articles

Free SQL Hosting

# of Domains: 1
# of SQL Server Databases: 1
Disk Space: 5GB
Bandwidth: Unmetered
SQL Server 2014
Monthly: $0.00
More Information About Free Shared SQL Server Hosting Plan

Free Hyper-V Hosting

Dedicated Memory:1GB
Disk Space: 25GB SSD
Bandwidth: Unmetered
Windows 2012/2008: Free
Monthly: $0.00
More Information About Free Windows Hyper-V Server

Dedicated SQL Server

CPU: Quad-Core X3440 CPU
RAM: 8GB RAM
Disk: 2x120GB SSD
RAID: RAID 1
Bandwidth: Unmetered
Windows 2012/2008: Free
Monthly: $79.00
More Information About Dedicated SQL Server with SSD
SQL Server Hosting | ASP.NET Hosting | DotNetNuke Hosting | Windows VPS Hosting | Dedicated Windows Server Hosting