Wednesday 24 November 2010

SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

I encountered this error this morning when my SQL Server instance wouldn't start after I made some connection changes yesterday. I had to make the changes because a needed an ODBC connection, and that would only seem to work if I configured it to use named pipes.

After checking the logs, I received the error "SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.".

So, I went back to undo each change I had made, and noticed that the last change I made was to enable VIA as a protocol for my SQL Server instance. Disabled that, and hey presto, SQL Server now starts fine.

The strange thing is that enabling VIA in my SQL Express instance didn't seem to cause the same issue on that server though.

8 comments:

  1. Had the same problem. HMMMM indeed.

    ReplyDelete
  2. thanks a loooooooooot

    ReplyDelete
  3. thank u very much , it really worked for me , u guys are so kind to newbies....

    ReplyDelete
  4. You saved my time and thought me how to fix this. Thanks a lot man. U;re great :)
    Thanks
    Shreenidhi

    ReplyDelete
  5. Thanks man, you just make my day.

    ReplyDelete
  6. muito grato pela por teres falhado um dia, pôs ele tornou-se experiência para muito, até para aqueles que postaram, agradecendo-te. Muito obrigado mais uma vez, retiraste-me de um buraco!!

    VAleu

    ReplyDelete
  7. that's made my day ... thanks.

    ReplyDelete