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

Posted on March 30, 2017 by RWallace Consulting, LLC

A recent client had this error on their MS SQL Server out of the blue. After much investigation and trial/error to correct. The following solution saved the day:

  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

Much thanks to the following article:

http://www.dedicatedsqlserver.com/HowTo/MSSQLSERVER_Fail_To_Start.aspx

About RWallace Consulting, LLC

Since 2002, RWallace Consulting, LLC has been developing software across a myriad of industries. Right now, we specialize in Microsoft .NET technologies.
This entry was posted in SQL Server. Bookmark the permalink.

Leave a comment