SCOM 2007 R2 create/install databases using DBCreateWizard.exe – even remotely!

Instead of using MSI to create SCOM databases, you have the option to use DBCreateWizard.exe which can be found in the SupportTools folder. DBCreateWizard also gives the option to create the databases remotely when using command line like shown below:

OPERATIONS MANAGER DATABASE

 

OPERATIONS MANAGER DATA WAREHOUSE DATABASE

DBCreateWizard.exe creates a log file starting with dbCreateWiz in the temp folder.

If DBCreateWizard.exe is started without command line parameters the GUI will show.
NOTE: It is not possible to create databases remote from the GUI!

SCOM 2007 R2 command line install

To install System Center Operations Manager from command line use the parameters highlighted below:

DATABASE

 

MANAGEMENT SERVER (RMS or MS)

 

CONSOLE (UI)

 

WEBCONSOLE 

 

AGENT

 

DATAWAREHOUSE (REPORTING DATABASE)

 

REPORTING SERVER