SCOM 2007 "Unexpected Shutdown" where is it?

By default it's not enabled so you have to create it
New -> Monitor Objects -> Windows Events -> Simple Event Detection -> Manual Reset -> select System Log
- Event ID: 6008
- Event Source: EventLog

But you will get this alert after the server is online again NOT when the server is down the reason why is because this message will write to event log after the windows startup and when SCOM agent detect this message it will forward to SCOM Server.

Server down -> no SCOM agent -> no engine to detect message -> no communication between server and agents

Actually when the server is down you will get alert from SCOM Server about "Management software failed", "Failed to connect to the computer" and if your server running another applications (sql, exchange, etc) you will get alerts from application management pack also...

Another thing is for this 2 alerts ("Management software failed", "Failed to connect to the computer" it will automatic closed when the server is online again. You might not get this alerts if you are running on virtualization platform because when the server reboot it might take less than 1 min.....

SCOM 2007 -> Setup cannot locate the SC database

Check out the SQL Server Configuration Manager to enable "TCP/IP" and "Named Pipes" especially when using remote database and SPN Registration also...

Changed of service name in SCOM 2007 R2

SCOM 2007 SP1 -> SCOM 2007 R2
"OpsMgr SDK Service" -> "System Center Data Access"
"OpsMgr SDK Service" -> "System Center Management Configuration"
"OpsMgr Health Service" -> "System Center Management"

MOMCertImport.exe error: ‘The application failed to initialize properly (0xc0150002). Click OK to terminate the application.

Problem is some .NET components is required.
Open momcertimport.exe with notepad and go to the end of the file you will see this..
assemblyIdentify ........ "Microsoft.VC90.CRT" version="9.0.30729.1"

so you need to get this library install on the server (Microsoft Virtual C++ 2008 SP1)

Microsoft Virtual C++ 2008 SP1 -> 9.0.30729.1
Microsoft Virtual C++ 2008 -> 9.0.21022.8

http://www.microsoft.com/DOWNLOADS/details.aspx?familyid=A5C84275-3B97-4AB7-A40D-3802B2AF5FC2&displaylang=en

Or...
Actually MOMCertImport.exe is just add an entry of certificate to the registry so it can be done manually..
1. Check the serial number of the certificates from Details tab (mmc -> certificates -> computer account)
2. Create new Binary Value "ChannelCertificateSerialNumber" -> HKLM\Software\Microsoft Operations Manager\3.0\Machine Settings but in the "REVERSE" order
Example : serial number is ab 12 cd 34 ef 56 -> enter it as 56 ef 34 cd 12 ab
Then restart health service
R1 -> "OpsMgr Health Service"
R2 -> "System Center Management"