Friday, September 12, 2008

Description of Typical Services Registry Keys Under Hkey_Local_Machine

After installing SQL2008 as a named instance, you can stop/start from a command line using NET STOP MSSQL$SQL2008 and NET START MSSQL$SQL2008.

Unfortunately mine failed with this error when I tried to start.

The SQL Server (SQL2008) service terminated with service-specific error 1455 (0x5AF).

Then I got this error.  The dreaded sysfader.

Application popup: SysFader: iexplore.exe - Application Error : The instruction at "0x30037c61" referenced memory at "0x00000000". The memory could not be "read".

Click on OK to terminate the program
Click on CANCEL to debug the program

Will try a reboot and see what happens.

I put together a quick C# utility that lists all services on a machine and provides searching capabilities called ListService.

From a command line:  ListService.exe %1

Where %1 is the service name you are searching for. Leave blank to show all services under the registry key SYSTEM\CurrentControlSet\Services

It’s called ListServiceSetup.msi and requires .NET 2.0 Framework and Windows Installer 3.1.

It’s only(!) 32k and you can delete the .config file.  Should be around 2k with the 10 lines of code in it… but that’s .NET for you.  The installation package is a whopping 342k.

You can download from here:

ListService beta installer

Description of Typical Services Registry Keys Under Hkey_Local_Machine

No comments: