October 26, 2010 at 11:52 pm
Hi All,
I'm stumped with a SQL Issue on my local machine, everything had been working fine then one day after a windows update the SQL Service would no longer start. I'm getting the following errors ...
*SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
*Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
*TDSSNIClient initialization failed with error 0x80090008, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Invalid algorithm specified.
*TDSSNIClient initialization failed with error 0x80090008, status code 0x80. Reason: Unable to initialize SSL support. Invalid algorithm specified.
The top error mentioned checking the error log which just lists the errors above.
Everything I've read on the web regarding similar errors all relate the encryption but encryption has never been turned on on this machine.
The machine is running XP with SQL 2008 R2 if that is any help.
The services are running using the Local System accounts, trying to change these between Local System, Local Service and Network Service return the "Invalid algorithm specified" error. Setting them to another local admin account doesn't work either. Note: Prior to the windows update everything worked fine with the current settings.
Hope someone can help, I've spent the last day and half trying to get it back up and running again with no luck.
Cheers
October 26, 2010 at 11:57 pm
dougjjj (10/26/2010)
everything had been working fine then one day after a windows update the SQL Service would no longer start.
What did the windows update install?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2010 at 12:30 pm
I would have to agree with Gail - something in the update has to have had a negative effect. As a suggestion, since you are utilizing Windows XP, do a System Restore to a date prior to when the issue started.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
October 27, 2010 at 4:42 pm
Nup no luck with the system restore, that was one of the first things I tried. This is the second time it has happened, the first time was a few months ago and I did a system restore then and it went back to normal. Unfortunately this time it happened a system restore didn't fix the problem.
October 27, 2010 at 6:36 pm
GilaMonster (10/26/2010)
dougjjj (10/26/2010)
everything had been working fine then one day after a windows update the SQL Service would no longer start.What did the windows update install?
I had a look through the updates and they were just generic windows updates, security updates to WMP, IIS, Printers, Codecs and a RPC call change etc ...
http://support.microsoft.com/?kbid=2290570
http://support.microsoft.com/?kbid=2259922
http://support.microsoft.com/?kbid=2124261
http://support.microsoft.com/?kbid=2121546
http://support.microsoft.com/?kbid=981322
http://support.microsoft.com/?kbid=2347290
http://support.microsoft.com/?kbid=982802
http://support.microsoft.com/?kbid=982665
Nothing jumped out looking related to the issue ...
October 27, 2010 at 8:50 pm
Tried an uninstall of the SQL Server Engine and reinstall and no luck, same error messages in the error log.
October 27, 2010 at 9:47 pm
I finally managed to get it back up and running again by just uninstalling windows updates until it started working again. I'm not sure exactly which one fixed it but uninstalling one of the following did it just incase someone else in the future has the same problem ...
Windows XP KB973687
Windows XP KB2115168
Windows XP KB982214
Windows XP KB2160329
Windows XP KB980436
Windows Media Player KB973540_WM9
Windows XP KB951978
Windows XP KB2079403
Windows XP KB981852
Windows XP KB971513
Windows XP KB2286198
October 28, 2010 at 1:12 am
Nice to hear that your Database server is up.
To find out reason of the issue occurred,
1) you can install the above mentioned windows update one by one
2) After installing each update reboot the machine
3) Verify if sql server service is up and running and you are able to connect to server.
By this, you will able to find due to which update, your db server got crashed.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply