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

Shared Hosting

# of Domains: 2
# of SQL Server Databases: 2
Disk Space: Unlimited
Bandwidth: Unlimited
Email: Unlimited
SQL Server 2008 R2
Monthly: $4.99
More Information About Unlimited Shared Windows Hosting Plan

Windows Hyper-V Server

Dedicated Memory:2GB
Disk Space: 200GB
Bandwidth: Unlimited
Windows 2008/2003: Free
Monthly: $49.99
More Information About Unlimited Windows Hyper-V Server

Dedicated SQL Server

CPU: Intel Dual-Core Sandy Bridge I3-2100
RAM: 8GB RAM
Disk: 2x320GB SATA
RAID: Host RAID 1
Bandwidth: Unlimited
Windows 2008/2003: Free
Monthly: $99.00
More Information About Unlimited Dedicated SQL Server
SQL Server Hosting | ASP.NET Hosting | DotNetNuke Hosting | Windows VPS Hosting | Dedicated Windows Server Hosting
Dedicated SQL Server with SSD | Powerful Dedicated SQL Server | Cheap Dedicated SQL Server | Dedicated SQL Server Promotion | Special Express SQL Server