I’ve had several times recently when I was on a client site, and nobody knew what server was hosting the Operations Manager database (the usual response is “I’ve slept since then”). Each time I end up digging around for a while so I thought it would make sense to post this. There are multiple ways to locate which server is providing the Operations Manager database:

1) Registry: Regedit to key HKLM\Software\Microsoft\Microsoft Operations Manager\3.0\Setup in the DatabaseServerName string. (Chapter 12, page 566 in System Center Operations Manager 2007 Unleashed book) on a management server.

2) Command prompt: From a command prompt type netstat and look for “Ms-sql-s”.

3) OpsMgr UI: Open the Monitoring node, Operations Manager folder, Management Group Diagram. Open the SystemCenterOperationsManager icon, highlight the RMS server underneath it, and at the bottom of the screen it shows the Operational Database Server Name and the Operational Database Name as well.

Thanks to Steve Ross, Kerrie Meyler, and Adam Rafels for their help gathering these up and hopefully I’ll be able to remember this next time I run into it as well!