Ok.. I was getting the following error in my event viewer/application log when I would try to start SQL server. I would try to start it and it would immediately fail.
“TDSSNIClient initialization failed with error 0×5, status code 0×51.”
The solution turned out to be rather simple; Open up SQL Configuration manager, and switch the account that the SQL server was running under to the Local System account.
Not necessarily secure, and wouldn’t do it for production but since I do development, it doesn’t matter too much. I’m not sure what caused this problem I recently went through the hell of installing Adobe CS3 but I’ve also had a number of packages get pushed down from the corporate SMS system as well.
Oh, I was also getting the following error in the application log.
UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.
The trick for this one is just to go change the permissions in the registry so the MicrosoftSQL keys can be updated.
