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

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

Advertisements

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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s