March 28, 2006

SQL Express 2005 died!

I have have an annoying problem. Essentially the SQL Express server is now unable to run on my laptop. What I have discovered was the fact that Read/Write permissions were removed from the Data folder holding the database files and the registry keys also were missing the necessary permissions. I have a pretty good idea how these permissions were incorrectly removed, but now I cannot get it fully restored. (think overzealous security team) I am hoping someone out there has experienced and solved this problem. Below are the messages I get in the event log:

UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.

TDSSNIClient initialization failed with error 0x5, status code 0x90.

TDSSNIClient initialization failed with error 0x5, status code 0x1.

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.

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 far I have restored access to the Data folder and the registry keys located at
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server and
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer. Yet it still fails to start the database service. At this point I may need to uninstall and reinstall SQL Express. I am hoping to avoid that as it will surely add more work and may not fully resolve the problem.

Posted by brennan at March 28, 2006 11:51 AM | TrackBack
Comments

Try Filemon, Regmon, and possibly Process Explorer. Hopefully they will show you the requests that are failing so you know where you need to change permissions.

http://www.sysinternals.com/Utilities/Filemon.html
http://www.sysinternals.com/Utilities/Regmon.html
http://www.sysinternals.com/Utilities/ProcessExplorer.html

Posted by: Kevin H at March 30, 2006 12:31 PM

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\SuperSocketNetLib

This was the key. I needed to add full control to the SQL 2005 User. It works now!

- Thanks Kevin

Posted by: Brennan Stehling at March 30, 2006 01:42 PM
Post a comment

Comment Rules

Express your opinions and provide feedback, but abide by the following guidelines:

  1. Use language appropriate to civil conversation. Profanity is not acceptable.
  2. Innuendo is not allowed. If you have a point, make it clearly.
  3. Insults towards the site author or the author of a comment will not be tolerated. The point is to provide a healthy exchange of viewpoints.
  4. Comments must pertain to the topic of the blog entry.

Comments which do not abide by the rules will be deleted.










Remember personal info?







[ Home ]